Re: [sqlite] No unicode characters in sqlite3 console prg
On 11 Aug 2018, at 5:51pm, Lars Frederiksen 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.?? It's a Windows thing. But I don't know how to fix it in Windows 10. Does Windows 10 still use code pages in the Console ? Try executing this command at the Console prompt before doing stuff with sqlite3: chcp 65001 Does this make things work properly ? If not, I would google the following string: "windows 10" "code page" console Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] No unicode characters in sqlite3 console prg
On 11 Aug 2018, at 17:51, Lars Frederiksen 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
[sqlite] No unicode characters in sqlite3 console prg
Hello, 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. It is not necessarily a problem as in my dbgrid of my program the unicode is shown correctly. I am just curious! Best Regards Lars ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
