Idid not check this way but I believe it would work now. I have hanged code page of cmd.exe into 65001 which is UTF-8. Now everything works J
Thanks for your effort. ZikO From: Simon Slavin-3 [via SQLite] [mailto:ml-node+s1065341n65608...@n5.nabble.com] Sent: 19 November 2012 14:33 To: ZikO Subject: Re: SQLite converts all unicode characters into ANSI On 19 Nov 2012, at 1:57am, ZikO <[hidden email]> wrote: > The script was written in Notepad++ > that controls which charset coding is used but I also double checked it in > Notepad and it indicated UTF-8; it can also be confirmed by reading the > script text file in Hex editor that shows BOM at the beginning: > [*ef bb bf* 43 52 45 41 54 45 20 54 41 42 4c 45 20] [CREATE TABLE] If you try the command INSERT INTO imiona (data,imie1,imie2,imie3) VALUES ('01/01/2012','Masława','Mieczysława','Mieszka'); (type it, do not use copy-and-paste) directly into the shell tool and then SELECT * FROM imiona; does it show the characters correctly or is it converting those too ? Simon. _______________________________________________ sqlite-users mailing list [hidden email] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _____ If you reply to this email, your message will be added to the discussion below: http://sqlite.1065341.n5.nabble.com/SQLite-converts-all-unicode-characters-into-ANSI-tp65589p65608.html To unsubscribe from SQLite converts all unicode characters into ANSI, click here <http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=65589&code=emViaWtAb3AucGx8NjU1ODl8MTA0OTg0NDEw> . <http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> NAML -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite-converts-all-unicode-characters-into-ANSI-tp65589p65611.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