On 8/23/06, Preston Z <[EMAIL PROTECTED]> wrote:
the problem is when i get the data through the C api with a call to sqlite3_get_table, the chars are missing/distorted.
Are they missing/distorted, or, is the method you are using to inspect them not understanding the encoding they are in. You do need to make sure that you put them in as UTF8, and then, when you retreive them, that you are examining/using them as UTF8. FWIW, I use SQLite all the time to put UTF8 text in and get UTF8 text out and I've never had a problem in either direction. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------