FreeTDS Development Group

["Joseph Geiser" <joe AT mail.paravisions.com>]

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