All I can say is this is not normal behavior. I use SQLite always with UTF-8 texts, even on command line (windows). As a test I suggest you create the db with the SQLite Expert.
gert 2012/11/17 ZikO <ze...@op.pl> > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users