freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] SELECT '' and TDS 7.0

From: Craig Davison <cd AT securityfocus.com>
To: freetds AT lists.ibiblio.org
Subject: [freetds] SELECT '' and TDS 7.0
Date: Tue, 14 Jan 2003 15:08:57 -0700

Hi,

I noticed some wierd behaviour with freetds 0.60.1 (and 0.53, 0.52). When
using TDS 7.0,
SELECT ''
returns NULL. However, with TDS4.2, it returns '' as expected.

With sqsh (megatron is set up for 7.0 in /etc/freetds/freetds.conf):
[8] megatron..1> select ''
[8] megatron..2> go

NULL

(1 row affected)

Again (megatron42 is set up for 4.2):
[9] megatron42..1> select ''
[9] megatron42..2> go

-

(1 row affected)

I've tried both the freetds RPMs and building myself from source. My DB
server is MS SQL Server 2000.

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