Skip to Content.
Sympa Menu

freetds - Re: [freetds] Re: Inserting empty strings into MS SQL Server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Scott Johnson" <scomps AT purplewire.org>
  • To: <joe AT mail.paravisions.com>, "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Cc:
  • Subject: Re: [freetds] Re: Inserting empty strings into MS SQL Server
  • Date: Mon, 9 Aug 2004 16:35:03 -0400

*This message was transferred with a trial version of CommuniGate(tm) Pro*
ahh ok, my mistake. Could have been an easy fix :)

----- Original Message -----
From: "Joseph Geiser" <joe AT mail.paravisions.com>
To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
Sent: Monday, August 09, 2004 4:06 PM
Subject: RE: [freetds] Re: Inserting empty strings into MS SQL Server


> *This message was transferred with a trial version of CommuniGate(tm) Pro*
> Scott Johnson writes,
>
> > I might be incorrect in stating this, but doesn't ('') equate
> > itself to
> > one apostrophe for the purpose of inserting that?
> >
> >
> > (1, 'foo', ' ', '', 'foo', 'foo', 'foo', 'foo', 'foo', 'foo', 'foo',
> > 'foo',
> > 'foo', 'foo', 'foo', 'foo', 'foo', 'foo', 'foo', 'foo', 'foo')
>
>
> Not in an INSERT, where the only characters in a column are '' -- this
> translates to "empty string" (not NULL). If the value had characters and
a
> double-apostrophe (ie: 'O''Malley') - then it would be an escaped
> apostrophe.
>
> HTH...
>
> Joe
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page