I am planning to store text in a database which has to accommodate a few
international languages.
In this case I have to use UTF-16LE encoding for my TEXT fields.
I know that once an encoding has been set for a database, it cannot be changed.
Do BLOBS are effected?
I guess I cannot mix TEXT UTF-8 and UTF-16 columns in the same data base, can
I?
Can I get away with a database encoded in UTF-8 by using sqlite3_bind_text16()
function for TEXT fields when I need UTF-16 text?
After opening empty database, I tried to execute:
sqlite3_exec(handle,"PRAGMA encoding = UTF-16",NULL,NULL,&zErr);
But I got the following error:
PRAMA error: near "-": syntax error. What did I do wrong?
Thank you for reading. Any comment appreciated!
Samuel
__________________________________________________________________
The new Internet Explorer® 8 - Faster, safer, easier. Optimized for Yahoo!
Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
