I can't comment on Anne's situation, but I too think there is something funny going on with charsets because of one small data point: I open and use a database using the '16' APIs (ie sqlite3_open16, sqlite3_prepare16, etc). When I tried to run an EXPLAIN QUERY PLAN statement (like "EXPLAIN QUERY PLAN SELECT id FROM LIST WHERE test=1" just as an example) using my typical prepare16, step16, etc code, I'd always get back an empty result. However, if I run the identical statement with sqlite3_exec (NOT the 16 version) the results came back as expected. After figuring this out I just worked around the problem, but it makes me think there might be something there.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 15, 2006 1:45 PM To: [email protected] Subject: [sqlite] Charset-Confusions Hi I have some confusion again. I have create the same Database 4 times and after that perform Insert some records. I dont change the SQL-Commands. 1. Compiler-Option Unicode and run "sqlite3_exec()" 2. Compiler-Option Multibyte and run "sqlite3_exec()" 3. Compiler-Option Unicode and run "sqlite3_prepare()" 4. Compiler-Option Multibyte and run "sqlite3_prepare()" Create Table and Insert Records works fine with sqlite3_prepare() on both charsets. I got no problems with write and followed read the written records and there field-values. Create Table first, Insert and followed Select to fetch Data works also fine with sqlite3_exec() if i define Multibyte. But the results are unusable, if i define Unicode (only German Umlauts). I have a look in SQLite-Source and found, that sqlite3_exec() after some lines self perform a Call to sqlite3_prepare(). If i dont need the Callback-Funtionality, can i start in my App directly sqlite3_prepare() instead sqlite3_exec() and get the same Result for "Inserts" and "Updates" (only)? An the 2. question: Is there any Really-Good-Admin-Tool to create DB and Table, to browse and maybe edit Fieldvalues in a grid? I have found 4 Admin-Programms. Some of them cannot open Version 3, some cannot differ Unicode and Multibytecharset, one of them has not a useful gui. Greetings from Germany Anne -- GMX Produkte empfehlen und ganz einfach Geld verdienen! Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner To find out more about Reuters visit www.about.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
