[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.

-- 
Nick


More information about the unixODBC-support mailing list