Skip to Content.
Sympa Menu

freetds - Re: [freetds] SELECT '' and TDS 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Craig Davison <cd AT securityfocus.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] SELECT '' and TDS 7.0
  • Date: Mon, 27 Jan 2003 09:51:20 -0700

On Mon, Jan 27, 2003 at 04:08:53PM +0100, ZIGLIO Frediano wrote:
> Problem is difference from an empty string and NULL. In TDS 4.2 when you
> issue a "SELECT ''" a single space is returned (' '). This cause a NULL
> string is represented as a empty string. TDS7 remove this limit allowing
> empty string (NULL is now a string of length -1, not 0).
> I don't remember if this was fixed in 0.60 or later...

I have to admit I haven't tried the CVS version, but it's broken in the
latest stable release (0.60 or 0.60.1).
Thanks for looking into this!

--
Craig Davison
Symantec Corporation
+1 (403) 213-3939 ext. 228




Archive powered by MHonArc 2.6.24.

Top of Page