> 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