> Le 13 août 2018 à 14:22, Lars Frederiksen <lars...@dadlnet.dk> a écrit :
>
> I use Windows 10 and have tried
> chcp 65001
> without any luck. Still the same questionmarks
> /Lars
Of course. :) That is Windows console. You also have to elect to use an
alternate font with your console, one that encompasses enough unicode glyphs
for your needs. Click the upper left corner of your console window, choose
properties, then font. You might have to find additional fonts and install
them.
Consider this workflow using a french speaking Windows 10:
I:\>chcp
Page de codes active : 850
I:\>sqlite3 école.db "create table école (élève text); insert into école
values('élisabeth');"
Comment: While my code page is 850, I type some extended characters to create a
file, a table, a column and a value all using at least one extended character
which is properly supported by my code page 850. The input to SQLite is
correctly interpreted (see proof later on). But I would not have been able to
enter any greek characters or arabic, not part of my code page 850.
I:\>sqlite3 école.db
SQLite version 3.24.0 2018-06-04 19:24:41
Enter ".help" for usage hints.
sqlite> .once test.sql
sqlite> .dump
sqlite> .q
I:\>type test.sql
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE ├®cole (├®l├¿ve text);
INSERT INTO "├®cole" VALUES('├®lisabeth');
COMMIT;
Comment: So when dumping to file, there SQLite properly outputs UTF-8 without
my code page settings getting in the way. That is nice and should never ever be
changed. The fact that it outputted UTF-8 can clearly be seen above because the
various extended characters, encoded as UTF8 appear as individual bytes mapped
to my default code page 850.
Now switch the console code page to UTF-8 (65001):
I:\>chcp 65001
Page de codes active : 65001
I:\>type test.sql
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE école (élève text);
INSERT INTO "école" VALUES('élisabeth');
COMMIT;
And the text file content appears OK, confirming the actuel text file data is
UTF-8 (which you could validate by other ways, using a text editor properly
supporting the encoding).
--
Best Regards, Meilleures salutations, Met vriendelijke groeten,
Olivier Mascia
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
