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
