[unixODBC-support] db2 null values
nick at lurcher.org
Wed Feb 22 08:11:59 GMT 2012
On 22/02/2012 00:47, LocoJay Dev wrote:
> when doing query on tables including null values i do not get these returned correctly.
> for example
> create table test.unixodbc(col1 varchar(2), col2 varchar(2))
> insert into test.unixodbc(col1,col2) values('a', 'b')
> insert into test.unixodbc(col1) values('c')
> insert into test.unixodbc(col2) values('d')
I would say its possibly down to a driver problem, unixODBC just passes
the indicator value back from SQLGetData.
If the build is 64 bit, I would check if the sizeof( SQLLEN ) is the
same with the driver manager, tools and apps and the driver.
More information about the unixODBC-support