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 10:43:03 -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...
>

Looks like it's fixed in CVS.

--
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