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

Joseph Geiser joe at mail.paravisions.com
Mon Aug 9 16:06:52 EDT 2004


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




More information about the FreeTDS mailing list