Skip to Content.
Sympa Menu

freetds - Re: [freetds] empty strings select as null bug

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: LacaK <lacak AT zoznam.sk>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] empty strings select as null bug
  • Date: Thu, 11 Jun 2015 07:39:04 +0200



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.





Archive powered by MHonArc 2.6.24.

Top of Page