freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] Empty VARCHAR parameters converted to NULL
- From: Joshua Lang <joshua.h.lang AT gmail.com>
- To: freetds AT lists.ibiblio.org
- Subject: [freetds] Empty VARCHAR parameters converted to NULL
- Date: Fri, 15 Jan 2016 17:41:34 -0800
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.
Thoughts?
-
[freetds] Empty VARCHAR parameters converted to NULL,
Joshua Lang, 01/15/2016
-
Re: [freetds] Empty VARCHAR parameters converted to NULL,
Frediano Ziglio, 01/19/2016
- Re: [freetds] Empty VARCHAR parameters converted to NULL, Joshua Lang, 01/19/2016
-
Re: [freetds] Empty VARCHAR parameters converted to NULL,
Frediano Ziglio, 01/19/2016
Archive powered by MHonArc 2.6.24.