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:49:42 -0700

On Mon, Jan 27, 2003 at 02:58:04PM -0000, Thompson, Bill D (London) wrote:
> All,
>
> I've done the following test, using latest snapshot freetds + sqsh 1.7
> (ct-library), TDSVER set to 70 accessing SQL 2000
>
[...]
>
> doesn't this prove that a null value prints as 'NULL' whereas select ''
> prints as spaces ?

If you write a program to verify this, you'll notice your test isn't proof.
For example, try any query that should produce '' with DBD::sybase; it
returns undef and not '' as it should.

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




Archive powered by MHonArc 2.6.24.

Top of Page