> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of ZikO > Sent: maandag 19 november 2012 02:57 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLite converts all unicode characters into ANSI > > Hello, > thanks for your answers. > > I downloaded both precompiled binaries and shell for windows from > www.sqlite.org. > > The script looks like this: > CREATE TABLE IF NOT EXISTS imiona ( > id INTEGER PRIMARY KEY, > data TEXT, > imie1 TEXT, > imie2 TEXT, > imie3 TEXT); <snip> > > D:\Wydarzenia\Events>sqlite3 imieniny.db < test.sql > Error: near line 1: near "´╗┐CREATE": syntax error > > I then used the conding UTF-8 without BOM and the command was accepted > but > unfortunately I get the strange result: > sqlite> select * from imiona; > 1 01/01/2012 Mas┼éawa Mieczys┼éawa Mieszka > 2 16/01/2012 Marcelego Walerii W┼éodzimie > 3 17/09/2012 Franciszka Lamberty Narcyza > 4 01/01/2012 Mas┼éawa Mieczys┼éawa Mieszka > 5 16/01/2012 Marcelego Walerii W┼éodzimie > 6 17/09/2012 Franciszka Lamberty Narcyza > > Now, I don't know how to test if the text is OK because SQLite2009Pro > displays everything converted to ANSI even ithough I set it to UTF-8 :/ > Perhaps this program is not very good then. What would you recommend, > instead? > > once again thanks for your effort towards this. I am really really surprised > this behaviour.
Could you try .read in sqlite3, instead of using a pipe. With the pipe the shell is responsible for reading your file and the forwarding to sqlite3, while using .read <filename> makes sqlite read the file, which should be fully transparent to whatever encoding you use. Bert _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users