On 17 Aug 2011, at 6:44am, swathi wrote: > I want to retrieve some german characters form the Sqlite . How > can i use it . Please Help me
Use the 16-bit routines from SQLite to store and retrieve characters. In other words, if you're binding text, see this page http://www.sqlite.org/c3ref/bind_blob.html and use int sqlite3_bind_text16 instead of sqlite3_bind_text . If you're using prepare/step/finalize then see this page http://www.sqlite.org/c3ref/prepare.html and use sqlite3_prepare16_v2 instead of sqlite3_prepare_v2 . The 16-bit routines expect to receive strings coded in Unicode, and return strings coded in Unicode. Make sure your program converts your strings to Unicode before storing them in the database, and understands that strings it retrieves from the database will be encoded as Unicode. Question for experts: Hmm. There's no sqlite3_exec16() ? Do I misunderstand how it would be useful ? Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
