[freetds] Re: Inserting empty strings into MS SQL Server
Scott Johnson
scomps at purplewire.org
Mon Aug 9 16:35:03 EDT 2004
*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
More information about the FreeTDS
mailing list