[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