[unixODBC-support] db2 null values

Nick Gorham nick at lurcher.org
Wed Feb 22 08:11:59 GMT 2012

On 22/02/2012 00:47, LocoJay Dev wrote:
> Hi
> 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 mailing list