On Sat, Nov 17, 2012 at 3:29 PM, ZikO <[email protected]> wrote: > 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?
I've used SQLite with Greek characters with success. Just a wild guess: are your scripts saved as ANSI text without a BOM? If so, you could try saving them as unicode or UTF-8 with a BOM and try again. Use Notepad's save as command to do this. Also, make sure that any tool you use to execute them is unicode-aware. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
