Skip to Content.
Sympa Menu

freetds - [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: [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




Archive powered by MHonArc 2.6.24.

Top of Page