Hi Simon, PRAGMA Encoding gave me "utf-8" and the db gives me correct greek letters in my DBgrid in my Delphi program. So that is ok! BTW: ταβέρνα η - the last letter represents the definite article :-) I will read more about PRAGMA - here I am absolutely blank. PRAGMA is also used in the FireDAC components of my Delphi programming tool Thank you very much.
/Lars -----Oprindelig meddelelse----- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Simon Slavin Sendt: 13. august 2018 16:24 Til: SQLite mailing list Emne: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg On 13 Aug 2018, at 1:45pm, Lars Frederiksen <lars...@dadlnet.dk> wrote: > This is the result: > > sqlite> Select GRAESK, hex(GRAESK), DANSK from gloser; > taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna "taverna" in greek should be "ταβέρνα". In UTF-8 I get CF84 CEB1 CEB2 CEAD CF81 CEBD CEB1 Examining what you show ... CF84 CEB1 CEB2 CEAD CF81 CEBD CEB1 20 CEB7 Which is the correct string with, for some reason, " η" on the end. So the encoding of your database should be UTF-8. It is possible that the contents of your database do not agree with the stated encoding of the database. Please execute the command PRAGMA encoding; in the shell tool and tell us what the result is. For details see <https://www.sqlite.org/pragma.html#pragma_encoding> if you get UTF-8, then the fault is entirely within Windows, and the database contains exactly what you would want. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
