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
