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.
It's exceedingly unlikely this is SQLite's problem. SQLite simply doesn't have enough information to do this, even if it wanted to. There's no way for it to tell that 'ą' is in any way related to 'a', or 'Ż' to 'z'. Double-check your input file: my guess is, some tool that processed the file earlier ended up stripping accents somehow. > 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? You mean, you paste into SQLite Manager's window, and the text appears unaccented there, even *before* you actually run your statements? Then it can't possibly be SQLite's problem - the text hasn't even reached SQLite at this point. At best, it could be a problem with SQLite Manager (which is a third-party application not developed or maintained by SQLite developers). But again, double-check the source data - all signs point to accents not being there in the first place. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
