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: "Joseph Geiser" <joe AT mail.paravisions.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Re: Inserting empty strings into MS SQL Server
  • Date: Mon, 9 Aug 2004 16:06:52 -0400

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





Archive powered by MHonArc 2.6.24.

Top of Page