Thank you for this Tim, I found the problem is cmd.exe in windows 7. I cannot believe that in 2012 the command processor still operate using old codepage OEM 850 by default. I have changed that to utf-8 and now everything’s correct. I am glad you have confirmed it works on MAC as well J
Best regards, ZikO From: Tim Streater-3 [via SQLite] [mailto:ml-node+s1065341n65615...@n5.nabble.com] Sent: 19 November 2012 18:35 To: ZikO Subject: Re: SQLite converts all unicode characters into ANSI On 19 Nov 2012 at 01:57, ZikO <[hidden email]> wrote: > The script looks like this: > CREATE TABLE IF NOT EXISTS imiona ( > id INTEGER PRIMARY KEY, > data TEXT, > imie1 TEXT, > imie2 TEXT, > imie3 TEXT); > > INSERT INTO imiona (data,imie1,imie2,imie3) VALUES > ('01/01/2012','Masława','Mieczysława','Mieszka'), > ('16/01/2012','Marcelego','Walerii','Włodzimierza'), > ('17/09/2012','Franciszka','Lamberty','Narcyza'); This works exactly as it should on my Mac, both inputting and displaying, so it's not sqlite. -- Cheers -- Tim _______________________________________________ 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-tp65589p65615.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-tp65589p65617.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