I have a slight problem with sqlite and its text encoding. I read from documents that sqlite handles UTF-8 by using a command PRAGMA encoding = "UTF-8"; etc. My database is to store Polish text. The database is going to be used with Qt later on. I have a script with two commands: CREATE TABLE ... and INSERT INTO ... This file is encoded in UTF-8. However, when I build and fill database via a command *sqlite3 myname.db < the_file.sql*, I create both database and the table but all specific characters such as ą, ć, ź, Ż etc. are automatically converted into a, c, z, Z etc. I thought it would be a problem with the command line. So I downloaded SQLite Manager 2009 and when I copy / pasted the whole script to execute it in SQLite Manager, I noticed the effect is exactly the same. Characters are automatically converted during copy / pasting. Is the SQLite limitted to use only with ANSI characters?
Can someone please help me? The application will be international and not only will I need Polish characters but Spanish etc. Thanks -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite-converts-all-unicode-characters-into-ANSI-tp65589.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
