Hi John You can execute the following SQL after opening your DB (but before inserting any rows):
"PRAGMA encoding=UTF16" http://www.sqlite.org/pragma.html Cheers, Dave. -----Original Message----- From: John Horton [mailto:john_horto...@hotmail.com] Sent: 10 February 2009 01:30 To: sqlite-users@sqlite.org Subject: [sqlite] sqlite_open_v2() vs sqlite_open16() Hello, I am new to sqlite, please could someone tell me how to open a UTF-16 databse using the sqlite_open_v2() API function ? Thanks and regards, John _________________________________________________________________ Hotmail, Messenger, Photos and more - all with the new Windows Live. Get started! http://www.download.live.com/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users