Empty strings are selected as NULL

[shawjef3]

Hello,
In SQL Server 2008 R2 I have some nvarchar fields that are nullable. When they are empty strings, they are selected as NULL in PostgreSQL.

Jeff

[shawjef3]

Sorry, this is a bug in freetds that was found in 2006 and apparently never fixed.

http://sourceforge.net/p/freetds/bugs/25/

[shawjef3]

After reading the thread more closely, they used stock freetds 0.64 and fixed the php library. I'll look at tds fdw to see if I can find a similar problem.

[shawjef3]

OK, it's not a problem with tds_fdw. I set my tds version to auto from 7.2, and empty nvarchars are coming through as empty varchars.

[shawjef3]

Setting the tds version to auto caused long nvarchars to be truncated to 255 characters. Setting the tds version to 8.0 fixed the truncation, but once again empty strings are being selected as NULL.

[GeoffMontee]

http://lists.ibiblio.org/pipermail/freetds/2015q2/029389.html

[GeoffMontee]

Fixed: b5f678c

[GeoffMontee]

Fixed in 1.0.3.