On 11 Aug 2018, at 17: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.
Using macOS Mavericks (10.9.5):
SQLite version 3.14.0 2016-08-08 13:40:27
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table x (q text);
sqlite> insert into x values ('∑ß∂π');
sqlite> select * from x;
q
----------
∑ß∂π
Seems to work.
--
Cheers -- Tim
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
