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 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 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:[email protected]] 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 <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
