Cleared this problem up - it was actually a conversion problem on my part (never rely on MFC to function correctly - always check!), SQLite works fine <blushing>
Dennis //-------- Software for animal shelters http://www.smartpethealth.com //-------- -----Original Message----- From: Dennis Volodomanov Sent: Wednesday, July 28, 2004 4:08 PM To: [EMAIL PROTECTED] Subject: [sqlite] Storing unicode Hello all, Can you please tell me how to store UNICODE in SQLite v3? I'm using the sqlite3_mprintf() functions with %q, but it doesn't handle UNICODE correctly - I pass in a CString with a UNICODE value, but on the output of this function I get an incorrect string. The program is of course compiled with all the necessary stuff for UNICODE to work and it does with other functions, it's only on the sqlite3_mprintf() generated string that there's no UNICODE stuff.