[freetds] Empty VARCHAR parameters converted to NULL
joshua.h.lang at gmail.com
Fri Jan 15 20:41:34 EST 2016
In the latest version of FreeTDS-dblib (0.95.79) I'm passing rpc VARCHAR
parameters of 0 length, but non-NULL (empty strings). FreeTDS seems to turn
these into NULL values before passing them on to SQL Server. From what I've
read, it seems as if older databases didn't support passing empty strings,
but newer ones do? (i.e. TDS 7.0+ do support empty strings).
It seems as this is a known issue, but I was wondering if it is possible to
fix it for the newer versions of SQL server? E.g. in dbrpcparam() passing a
non-NULL pointer to the 'value' parameter and a 0 to 'datalen' would
indicate an empty string is desired if possible.
More information about the FreeTDS