Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

2018-08-13 Thread Lars Frederiksen
TERNAL] Re: No unicode characters in sqlite3 console prg On 13 Aug 2018, at 1:45pm, Lars Frederiksen wrote: > This is the result: > > sqlite> Select GRAESK, hex(GRAESK), DANSK from gloser; > taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna "taverna" in greek should be &q

Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

2018-08-13 Thread Simon Slavin
On 13 Aug 2018, at 1:45pm, Lars Frederiksen 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

Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

2018-08-13 Thread Lars Frederiksen
Sendt: 13. august 2018 15:14 Til: 'SQLite mailing list' Emne: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg It tells me (courtesy of findencoding.com) that the contents is encoded in one of - utf-8 (most probable) - iso-8859-10 - iso-8859-14 - iso-8859-16 - iso-20222-cn

Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

2018-08-13 Thread Hick Gunter
Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Lars Frederiksen Gesendet: Montag, 13. August 2018 14:46 An: 'SQLite mailing list' Betreff: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg Hi Hick Gunter

Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

2018-08-13 Thread Lars Frederiksen
source the encodes in ISO. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Lars Frederiksen Gesendet: Montag, 13. August 2018 14:24 An: 'SQLite mailing list' Betreff: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console

Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

2018-08-13 Thread Hick Gunter
: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Lars Frederiksen Gesendet: Montag, 13. August 2018 14:24 An: 'SQLite mailing list' Betreff: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg Hi Hick Gunter, I do not know exactly what you

Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

2018-08-13 Thread Simon Slavin
On 13 Aug 2018, at 1:23pm, Lars Frederiksen wrote: > I use versio 3.19 > SQLite version 3.19.3 2017-06-08 14:26:16 Lars, Please download the current version of the shell tool from the "Precompiled Binaries for Windows" -- "sqlite-tools-win32-x86-324.zip". section of

Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

2018-08-13 Thread Lars Frederiksen
An: 'SQLite mailing list' Betreff: [EXTERNAL] Re: [sqlite] No unicode characters in sqlite3 console prg I use versio 3.19 Here is a print from cmd: SQLite version 3.19.3 2017-06-08 14:26:16 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILE

Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

2018-08-13 Thread Hick Gunter
: [EXTERNAL] Re: [sqlite] No unicode characters in sqlite3 console prg I use versio 3.19 Here is a print from cmd: SQLite version 3.19.3 2017-06-08 14:26:16 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent dat