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