Re: Characters disappearing in REALSQLdatabase

[Joe Strout <joe at inspiringapps dot com>]

On Jan 31, 2008, at 9:13 PM, lveillette wrote:

> I'm trying to save the following string: "D‘Amico" to a  
> REALSQLdatabase, but
> it seems that it ends up in the database as DAmico, no matter what  
> encoding
> I use and even though my start encoding is utf-8.

How are you trying to save it?  If you're building an SQL command,  
remember that single quotes are string delimiters.  You need to  
double them, e.g.:

  db.SQLExecute "UPDATE FOO SET NAME='D''Amico' WHERE ID=42"

Best,
- Joe


--
Joe Strout
Inspiring Applications, Inc.
http://www.InspiringApps.com



_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>