Hi everybody, And thank you very much for your help. The problem is not a BIG issue for me because i primarily use the console program for creating databases. The unicode chrs are even inserted correct in the greek field, because I can read them correctly in my DBGrid of my Delphi program. I just think it is an odd "behavior" of the cmd, but never mind. I might try to experiment a little with codepages etc and see if this helps. Thank you! Lars
-----Oprindelig meddelelse----- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Hick Gunter Sendt: 13. august 2018 15:14 Til: 'SQLite mailing list' Emne: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg It tells me (courtesy of findencoding.com) that the contents is encoded in one of - utf-8 (most probable) - iso-8859-10 - iso-8859-14 - iso-8859-16 - iso-20222-cn - iso-2022-cn-ext While your console is probably expecting either a windows or an incompatible ISO encoding. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Lars Frederiksen Gesendet: Montag, 13. August 2018 14:46 An: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg Hi Hick Gunter, This is the result: sqlite> Select GRAESK, hex(GRAESK), DANSK from gloser; taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna de µ?? ?e?...|CEB4CEB520CEBCCEBFCF8520CEBBCEB5CF822E2E2E|sig mig engang. (egl "du fortæller mig ikke") d?µ?s?????f?? ?/?|CEB4CEB7CEBCCEBFCF83CEB9CEBFCEB3CF81CEACCF86CEBFCF8220CEBF2FCEB7|journalist ???µa t?|CEBACEADCF81CEBCCEB120CF84CEBF|mønt, småmønt ??p??a ?|CEBACEBFCF80CEADCEBBCEB120CEB7|pige µa??t??a ?|CEBCCEB1CEB8CEAECF84CF81CEB9CEB120CEB7|elev, skoleelev (kvindelig) µa??t?? ?|CEBCCEB1CEB8CEB7CF84CEAECF8220CEBF|elev, skoleelev (mandlig) µp?????? t?|CEBCCF80CEBFCF85CEBACEACCEBBCEB920CF84CEBF|flaske ?p??|CF8CCF80CF89CF82|(konj) som, ligesom, sådan som; eftersom p?t??? t?|CF80CEBFCF84CEAECF81CEB920CF84CEBF|glas (Både glas og flaske er intetkøn som vin. Øl er hunkøn) p.?.= pa?ade??µat?? ????|CF802ECF872E3D20CF80CEB1CF81CEB1CEB4CEB5CEAFCEB3CEBCCEB1CF84CEBFCF8220CF87CEACCF81CEB7|f.eks. (for eksempel) taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna de µ?? ?e?...|CEB4CEB520CEBCCEBFCF8520CEBBCEB5CF822E2E2E|sig mig engang. (egl "du fortæller mig ikke") d?µ?s?????f?? ?/?|CEB4CEB7CEBCCEBFCF83CEB9CEBFCEB3CF81CEACCF86CEBFCF8220CEBF2FCEB7|journalist ???µa t?|CEBACEADCF81CEBCCEB120CF84CEBF|mønt, småmønt ??p??a ?|CEBACEBFCF80CEADCEBBCEB120CEB7|pige µa??t??a ?|CEBCCEB1CEB8CEAECF84CF81CEB9CEB120CEB7|elev, skoleelev (kvindelig) µa??t?? ?|CEBCCEB1CEB8CEB7CF84CEAECF8220CEBF|elev, skoleelev (mandlig) µp?????? t?|CEBCCF80CEBFCF85CEBACEACCEBBCEB920CF84CEBF|flaske ?p??|CF8CCF80CF89CF82|(konj) som, ligesom, sådan som; eftersom p?t??? t?|CF80CEBFCF84CEAECF81CEB920CF84CEBF|glas (Både glas og flaske er intetkøn som vin. Øl er hunkøn) p.?.= pa?ade??µat?? ????|CF802ECF872E3D20CF80CEB1CF81CEB1CEB4CEB5CEAFCEB3CEBCCEB1CF84CEBFCF8220CF87CEACCF81CEB7|f.eks. (for eksempel) a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men sqlite> Does it tell you whats wrong? /Lars -----Oprindelig meddelelse----- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Hick Gunter Sendt: 13. august 2018 14:34 Til: 'SQLite mailing list' Emne: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg Select graesk, hex(graesk), dansk from gloser; Check the hex output to see if it conforms to UTF specs; if so, then your console is expecting a different encoding (probably ISO). If not, then your data was probably entered from a source the encodes in ISO. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Lars Frederiksen Gesendet: Montag, 13. August 2018 14:24 An: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg Hi Hick Gunter, I do not know exactly what you mean by this (hex(<textfield>))? /Lars -----Oprindelig meddelelse----- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Hick Gunter Sendt: 13. august 2018 14:07 Til: 'SQLite mailing list' Emne: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg You need to show hex(<textfield>) before anyone can verify what encoding is stored. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Lars Frederiksen Gesendet: Montag, 13. August 2018 14:03 An: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org> Betreff: [EXTERNAL] Re: [sqlite] No unicode characters in sqlite3 console prg I use versio 3.19 Here is a print from cmd: SQLite version 3.19.3 2017-06-08 14:26:16 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .open flashcard.db sqlite> select * from Gloser; 2|taß???a ?|taverna|[01_16] 3|taß???a ?|taverna|[01_16] 4|taß???a ?|taverna|[01_16] 5|taß???a ?|taverna|[01_16] 16|taß???a ?|taverna|[01_16] 17|taß???a ?|taverna|[01_16] 18|taß???a ?|taverna|[01_16] 19|de µ?? ?e?...|sig mig engang. (egl "du fortæller mig ikke")|[01_08] 20|d?µ?s?????f?? ?/?|journalist|[01_08] 21|???µa t?|mønt, småmønt|[01_08] 22|??p??a ?|pige|[01_08] 23|µa??t??a ?|elev, skoleelev (kvindelig)|[01_08] 24|µa??t?? ?|elev, skoleelev (mandlig)|[01_08] 25|µp?????? t?|flaske|[01_08] 26|?p??|(konj) som, ligesom, sådan som; eftersom|[01_08] 27|p?t??? t?|glas (Både glas og flaske er intetkøn som vin. Øl er 27|hunkøn)|[01_08] 28|p.?.= pa?ade??µat?? ????|f.eks. (for eksempel)|[01_08] 29|taß???a ?|taverna|[01_16] 30|taß???a ?|taverna|[01_16] 31|de µ?? ?e?...|sig mig engang. (egl "du fortæller mig ikke")|[01_08] 32|d?µ?s?????f?? ?/?|journalist|[01_08] 33|???µa t?|mønt, småmønt|[01_08] 34|??p??a ?|pige|[01_08] 35|µa??t??a ?|elev, skoleelev (kvindelig)|[01_08] 36|µa??t?? ?|elev, skoleelev (mandlig)|[01_08] 37|µp?????? t?|flaske|[01_08] 38|?p??|(konj) som, ligesom, sådan som; eftersom|[01_08] 39|p?t??? t?|glas (Både glas og flaske er intetkøn som vin. Øl er 39|hunkøn)|[01_08] 40|p.?.= pa?ade??µat?? ????|f.eks. (for eksempel)|[01_08] 41|a???|men|[01_10] 42|a???|men|[01_10] 43|a???|men|[01_10] 44|a???|men|[01_10] 45|a???|men|[01_10] 46|a???|men|[01_10] 47|a???|men|[01_10] 48|a???|men|[01_10] The second field should show greek words but only the letters that are identical in danish and greek is shown. The pure greek letters like β, γ, δ, ε, η etc are shown as questionmarks. Do you want me to send you the database? Best Regards Lars -----Oprindelig meddelelse----- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Rowan Worth Sendt: 13. august 2018 03:21 Til: SQLite mailing list Emne: Re: [sqlite] No unicode characters in sqlite3 console prg On 12 August 2018 at 00:51, Lars Frederiksen <lars...@dadlnet.dk> wrote: > Is this an error of my windows 10 cmd prompt or is it a general > problem that the sqlite3 console is not able to show unicode in the > cmd-window.?? > > No problem writing to the database and show (greek) unicode characters > in the cmd prompt as I key them, but when I want to show the data with > the SQL SELECT * FROM Gloser then the greek word is shown with most of > its letters as questionmarks. > What version of sqlite are you using? There was significant efforts to improve windows console unicode handling awhile back, which I think made it in for 3.12/3.13. If you're still seeing issues with a recent sqlite can you provide a short example which reproduces the issue? -Rowan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users