On Mar 6, 2006, at 9:21 AM, Joseph J. Strout wrote:
Ed said this data was coming from an EditField; I don't believe you
can get a null character from there.
Yeah, I forgot about the Editfield.
You are able to insert control characters by doing Ctrl- combos (at
least on my Macintosh PowerBook), but I don't know if they will work
in an Editfield or if you can insert a NULL character.
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.
True. I have the most experience with MySQL which uses the backslash
as the escape character. I knew that SQLite uses the ' to escape
single-quotes but I wasn't sure if the backslash might also be used.
_______________________________________________
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>
