freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] SELECT '' and TDS 7.0

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

[freetds] SELECT '' and TDS 7.0, Craig Davison, 01/14/2003
- Re: [freetds] SELECT '' and TDS 7.0, James K. Lowden, 01/14/2003
  - Re: [freetds] SELECT '' and TDS 7.0, Craig Davison, 01/26/2003
    - Re: [freetds] SELECT '' and TDS 7.0, James K. Lowden, 01/26/2003
- <Possible follow-up(s)>
- RE: [freetds] SELECT '' and TDS 7.0, Thompson, Bill D (London), 01/27/2003
  - Re: [freetds] SELECT '' and TDS 7.0, Craig Davison, 01/27/2003
- RE: [freetds] SELECT '' and TDS 7.0, ZIGLIO Frediano, 01/27/2003
  - Re: [freetds] SELECT '' and TDS 7.0, Craig Davison, 01/27/2003
    - Re: [freetds] SELECT '' and TDS 7.0, Craig Davison, 01/27/2003
      - Re: [freetds] SELECT '' and TDS 7.0, Frediano Ziglio, 01/27/2003