Re: empty strings select as null bug

LacaK <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
>
> tds_fdw assumes a column is NULL if dbdatlen() returns 0:
I am using for testing NULL dbdata(), which should return nil for NULL data.
(In my case I know, that column exists)

 From Sybase documentation:
"A NULL BYTE pointer is returned if there is no such column or if the 
data has a null value. To make sure that the data is really a null 
value, you should always check for a return of 0 from *dbdatlen*."

 From Microsoft documentation:
"A NULL BYTE pointer is returned if there is no such column or if the 
data has a null value. To make sure that the data is really a null 
value, check for a return of 0 from *dbdatlen*."

So you can use: dbdata()==nil && dbdatlen()==0

-Laco.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.