On Mar 06, 2006, at 10:21 AM, Joseph J. Strout wrote:
At 8:53 AM -0800 3/6/06, Phil M wrote:
I would think that the NULL character (0x00) might cause problems,
and possibly the backslash character (\).
Ed said this data was coming from an EditField; I don't believe you
can get a null character from there.
As for backslashes, there's nothing in the SQL standard that makes
them special -- in fact the ONLY special character in standard SQL is
the single-quote. But if you're using some nonstandard SQL
implementation that treats the backslash as special, then you'll
probably want to replace each "\" with "\\" as well.
And some other non-standard behaviors permit using double quotes to
enclose the value instead so you have to double those up when they are
used to enclose the value and NOT the single quote.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
