> -----Original Message-----
> From: [email protected] [mailto:sqlite-users-
> [email protected]] On Behalf Of ZikO
> Sent: maandag 19 november 2012 02:57
> To: [email protected]
> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
