For the command prompt best I can suggest is changing the font to one of the
TrueType fonts listed there like Lucida Console, then not touching the code
page. Doing chcp 65001 <used> to help, but then in some release something got
added to the CLI to try and help with that automatically. With the examples you
gave I'm still not seeing the Euro sign, but at least I'm seeing the é.
I haven't messed with it in a while, but also note that you can potentially get
issues when using the alt+4numbers to enter something on the command line if
you've messed with the code page. You can do alt+0233 to get the é for example,
and the glyph on the screen will show the accent, and if you do a select
statement it will show the same glyph with the accent, but the data that
actually got inserted was something different. The code page just interpreted
the "incorrect" raw data to be what you were expecting to see. If there's ever
a doubt you can use the unicode() function to get a code point value. If the
console can't display the resulting 0-9 numerals ok, then there's a bigger
problem to worry about.
D:\>chcp
Active code page: 437
D:\>sqlite3
SQLite version 3.19.2 2017-05-25 16:50:27
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> select char(233);
char(233)
é
sqlite> select unicode(char(233));
unicode(char(233))
233
sqlite> select unicode('é');--input with alt+0233
unicode('é')
233
sqlite> .exit
D:\>chcp 65001
Active code page: 65001
D:\>sqlite3
SQLite version 3.19.2 2017-05-25 16:50:27
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> select char(233);
char(233)
�
sqlite> select unicode(char(233));
unicode(char(233))
233
sqlite> select unicode('é');--input with alt+0233, crashes back to command
prompt
D:\>
-----Original Message-----
From: sqlite-users [mailto:[email protected]] On
Behalf Of Shane Dev
Sent: Sunday, June 04, 2017 4:06 PM
To: [email protected]
Subject: [SPAM] [sqlite] Fwd: How to correctly display unicode characters in
Windows 10 / cmd.exe / sqlite3.exe?
Importance: Low
Hello,
After logging in to Windows 10, I open a command prompt (cmd.exe) and
change the code page to Unicode (UTF-8)
>chcp 65001
Active code page: 65001
then I test this with a UTF-8 file -
>type utf8test.txt
néo66€
next I execute sqlite-tools-win32-x86-3190200\sqlite3.exe and check the
encoding
sqlite> pragma encoding;
UTF-8
then I try to print some characters to screen -
sqlite> select char(0x006e); --Unicode LATIN SMALL LETTER N
n
sqlite> select char(0x00e9); --Unicode LATIN SMALL LETTER E WITH ACUTE
sqlite> select char(0x006f); --Unicode LATIN SMALL LETTER O
o
sqlite> select char(0x20ac); --Unicode EURO SIGN
?
only the ascii characters are displayed correctly. Next I test outputting
the euro sign to a file -
sqlite> .once eurotest.txt
sqlite> select char(0x20ac); --unicode EURO SIGN
sqlite> .quit
.. and from the command prompt -
>type eurotest.txt
€
Why can't I display these Unicode characters from sqlite3 command line
utility?
P.S I have a similar in powershell but not in Ubuntu.
_______________________________________________
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
