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

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

2018-08-13 Thread Lars Frederiksen

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  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

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 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

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

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

2018-08-13 Thread Lars Frederiksen

Hi everybody,

And thank you very much for your help. 
The problem is not a BIG issue for me because i primarily use the console 
program for creating databases. The unicode chrs are even inserted correct in 
the greek field, because I can read them correctly in my DBGrid of my Delphi 
program.
I just think it is an odd "behavior" of the cmd, but never mind. I might try to 
experiment a little with codepages etc and see if this helps.
Thank you!
Lars

-Oprindelig meddelelse-
Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På 
vegne af Hick Gunter
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
- iso-2022-cn-ext

While your console is probably expecting either a windows or an incompatible 
ISO encoding.

-Ursprüngliche 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,

This is the result:

sqlite> Select GRAESK, hex(GRAESK), DANSK from gloser;
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
de µ?? ?e?...|CEB4CEB520CEBCCEBFCF8520CEBBCEB5CF822E2E2E|sig mig engang. (egl 
"du fortæller mig ikke") d?µ?s?f?? 
?/?|CEB4CEB7CEBCCEBFCF83CEB9CEBFCEB3CF81CEACCF86CEBFCF8220CEBF2FCEB7|journalist
???µa t?|CEBACEADCF81CEBCCEB120CF84CEBF|mønt, småmønt ??p??a 
?|CEBACEBFCF80CEADCEBBCEB120CEB7|pige
µa??t??a ?|CEBCCEB1CEB8CEAECF84CF81CEB9CEB120CEB7|elev, skoleelev (kvindelig) 
µa??t?? ?|CEBCCEB1CEB8CEB7CF84CEAECF8220CEBF|elev, skoleelev (mandlig) µp?? 
t?|CEBCCF80CEBFCF85CEBACEACCEBBCEB920CF84CEBF|flaske
?p??|CF8CCF80CF89CF82|(konj) som, ligesom, sådan som; eftersom p?t??? 
t?|CF80CEBFCF84CEAECF81CEB920CF84CEBF|glas (Både glas og flaske er intetkøn som 
vin. Øl er hunkøn) p.?.= pa?ade??µat?? 
|CF802ECF872E3D20CF80CEB1CF81CEB1CEB4CEB5CEAFCEB3CEBCCEB1CF84CEBFCF8220CF87CEACCF81CEB7|f.eks.
 (for eksempel) taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
de µ?? ?e?...|CEB4CEB520CEBCCEBFCF8520CEBBCEB5CF822E2E2E|sig mig engang. (egl 
"du fortæller mig ikke") d?µ?s?f?? 
?/?|CEB4CEB7CEBCCEBFCF83CEB9CEBFCEB3CF81CEACCF86CEBFCF8220CEBF2FCEB7|journalist
???µa t?|CEBACEADCF81CEBCCEB120CF84CEBF|mønt, småmønt ??p??a 
?|CEBACEBFCF80CEADCEBBCEB120CEB7|pige
µa??t??a ?|CEBCCEB1CEB8CEAECF84CF81CEB9CEB120CEB7|elev, skoleelev (kvindelig) 
µa??t?? ?|CEBCCEB1CEB8CEB7CF84CEAECF8220CEBF|elev, skoleelev (mandlig) µp?? 
t?|CEBCCF80CEBFCF85CEBACEACCEBBCEB920CF84CEBF|flaske
?p??|CF8CCF80CF89CF82|(konj) som, ligesom, sådan som; eftersom p?t??? 
t?|CF80CEBFCF84CEAECF81CEB920CF84CEBF|glas (Både glas og flaske er intetkøn som 
vin. Øl er hunkøn) p.?.= pa?ade??µat?? 
|CF802ECF872E3D20CF80CEB1CF81CEB1CEB4CEB5CEAFCEB3CEBCCEB1CF84CEBFCF8220CF87CEACCF81CEB7|f.eks.
 (for eksempel) a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men 
a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men 
a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men
sqlite>

Does it tell you whats wrong?
/Lars


-Oprindelig meddelelse-
Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På 
vegne af Hick Gunter
Sendt: 13. august 2018 14:34
Til: 'SQLite mailing list'
Emne: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

Select graesk, hex(graesk), dansk from gloser;

Check the hex output to see if it conforms to UTF specs; if so, then your 
console is expecting a different encoding (probably ISO). If not, then your 
data was probably entered from a 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 
prg

Hi Hick Gunter,
I do not know exactly what you mean by this (hex())?
/Lars

-Oprindelig meddelelse-
Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På 
vegne af Hick Gunter
Sendt: 13. august 2018 14:07
Til: 'SQLite mailing list'
Emne: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

You need to show hex() before anyone

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

2018-08-13 Thread Hick Gunter

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
- iso-2022-cn-ext

While your console is probably expecting either a windows or an incompatible 
ISO encoding.

-Ursprüngliche 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,

This is the result:

sqlite> Select GRAESK, hex(GRAESK), DANSK from gloser;
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
de µ?? ?e?...|CEB4CEB520CEBCCEBFCF8520CEBBCEB5CF822E2E2E|sig mig engang. (egl 
"du fortæller mig ikke") d?µ?s?f?? 
?/?|CEB4CEB7CEBCCEBFCF83CEB9CEBFCEB3CF81CEACCF86CEBFCF8220CEBF2FCEB7|journalist
???µa t?|CEBACEADCF81CEBCCEB120CF84CEBF|mønt, småmønt ??p??a 
?|CEBACEBFCF80CEADCEBBCEB120CEB7|pige
µa??t??a ?|CEBCCEB1CEB8CEAECF84CF81CEB9CEB120CEB7|elev, skoleelev (kvindelig) 
µa??t?? ?|CEBCCEB1CEB8CEB7CF84CEAECF8220CEBF|elev, skoleelev (mandlig) µp?? 
t?|CEBCCF80CEBFCF85CEBACEACCEBBCEB920CF84CEBF|flaske
?p??|CF8CCF80CF89CF82|(konj) som, ligesom, sådan som; eftersom p?t??? 
t?|CF80CEBFCF84CEAECF81CEB920CF84CEBF|glas (Både glas og flaske er intetkøn som 
vin. Øl er hunkøn) p.?.= pa?ade??µat?? 
|CF802ECF872E3D20CF80CEB1CF81CEB1CEB4CEB5CEAFCEB3CEBCCEB1CF84CEBFCF8220CF87CEACCF81CEB7|f.eks.
 (for eksempel) taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
de µ?? ?e?...|CEB4CEB520CEBCCEBFCF8520CEBBCEB5CF822E2E2E|sig mig engang. (egl 
"du fortæller mig ikke") d?µ?s?f?? 
?/?|CEB4CEB7CEBCCEBFCF83CEB9CEBFCEB3CF81CEACCF86CEBFCF8220CEBF2FCEB7|journalist
???µa t?|CEBACEADCF81CEBCCEB120CF84CEBF|mønt, småmønt ??p??a 
?|CEBACEBFCF80CEADCEBBCEB120CEB7|pige
µa??t??a ?|CEBCCEB1CEB8CEAECF84CF81CEB9CEB120CEB7|elev, skoleelev (kvindelig) 
µa??t?? ?|CEBCCEB1CEB8CEB7CF84CEAECF8220CEBF|elev, skoleelev (mandlig) µp?? 
t?|CEBCCF80CEBFCF85CEBACEACCEBBCEB920CF84CEBF|flaske
?p??|CF8CCF80CF89CF82|(konj) som, ligesom, sådan som; eftersom p?t??? 
t?|CF80CEBFCF84CEAECF81CEB920CF84CEBF|glas (Både glas og flaske er intetkøn som 
vin. Øl er hunkøn) p.?.= pa?ade??µat?? 
|CF802ECF872E3D20CF80CEB1CF81CEB1CEB4CEB5CEAFCEB3CEBCCEB1CF84CEBFCF8220CF87CEACCF81CEB7|f.eks.
 (for eksempel) a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men 
a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men 
a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men a???|CEB1CEBBCEBBCEAC|men
sqlite>

Does it tell you whats wrong?
/Lars


-Oprindelig meddelelse-
Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På 
vegne af Hick Gunter
Sendt: 13. august 2018 14:34
Til: 'SQLite mailing list'
Emne: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

Select graesk, hex(graesk), dansk from gloser;

Check the hex output to see if it conforms to UTF specs; if so, then your 
console is expecting a different encoding (probably ISO). If not, then your 
data was probably entered from a 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 
prg

Hi Hick Gunter,
I do not know exactly what you mean by this (hex())?
/Lars

-Oprindelig meddelelse-
Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På 
vegne af Hick Gunter
Sendt: 13. august 2018 14:07
Til: 'SQLite mailing list'
Emne: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

You need to show hex() before anyone can verify what encoding is 
stored.

-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im 
Auftrag von Lars Frederiksen
Gesendet: Montag, 13. August 2018 14:03
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 FILENAME" to reopen on a persistent database.
sqlite> .open flashcard.db
sqlite> select * from Gloser;
2|taß???a ?|taverna|[01_16]
3|taß???a ?|taverna|[01_16]
4|taß???a ?|taverna|[01_16]
5|taß???a ?|taverna|[01_16]
16|t

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

2018-08-13 Thread Lars Frederiksen

Hi Hick Gunter,

This is the result:

sqlite> Select GRAESK, hex(GRAESK), DANSK from gloser;
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
de µ?? ?e?...|CEB4CEB520CEBCCEBFCF8520CEBBCEB5CF822E2E2E|sig mig engang. (egl 
"du fortæller mig ikke")
d?µ?s?f?? 
?/?|CEB4CEB7CEBCCEBFCF83CEB9CEBFCEB3CF81CEACCF86CEBFCF8220CEBF2FCEB7|journalist
???µa t?|CEBACEADCF81CEBCCEB120CF84CEBF|mønt, småmønt
??p??a ?|CEBACEBFCF80CEADCEBBCEB120CEB7|pige
µa??t??a ?|CEBCCEB1CEB8CEAECF84CF81CEB9CEB120CEB7|elev, skoleelev (kvindelig)
µa??t?? ?|CEBCCEB1CEB8CEB7CF84CEAECF8220CEBF|elev, skoleelev (mandlig)
µp?? t?|CEBCCF80CEBFCF85CEBACEACCEBBCEB920CF84CEBF|flaske
?p??|CF8CCF80CF89CF82|(konj) som, ligesom, sådan som; eftersom
p?t??? t?|CF80CEBFCF84CEAECF81CEB920CF84CEBF|glas (Både glas og flaske er 
intetkøn som vin. Øl er hunkøn)
p.?.= pa?ade??µat?? 
|CF802ECF872E3D20CF80CEB1CF81CEB1CEB4CEB5CEAFCEB3CEBCCEB1CF84CEBFCF8220CF87CEACCF81CEB7|f.eks.
 (for eksempel)
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna
de µ?? ?e?...|CEB4CEB520CEBCCEBFCF8520CEBBCEB5CF822E2E2E|sig mig engang. (egl 
"du fortæller mig ikke")
d?µ?s?f?? 
?/?|CEB4CEB7CEBCCEBFCF83CEB9CEBFCEB3CF81CEACCF86CEBFCF8220CEBF2FCEB7|journalist
???µa t?|CEBACEADCF81CEBCCEB120CF84CEBF|mønt, småmønt
??p??a ?|CEBACEBFCF80CEADCEBBCEB120CEB7|pige
µa??t??a ?|CEBCCEB1CEB8CEAECF84CF81CEB9CEB120CEB7|elev, skoleelev (kvindelig)
µa??t?? ?|CEBCCEB1CEB8CEB7CF84CEAECF8220CEBF|elev, skoleelev (mandlig)
µp?? t?|CEBCCF80CEBFCF85CEBACEACCEBBCEB920CF84CEBF|flaske
?p??|CF8CCF80CF89CF82|(konj) som, ligesom, sådan som; eftersom
p?t??? t?|CF80CEBFCF84CEAECF81CEB920CF84CEBF|glas (Både glas og flaske er 
intetkøn som vin. Øl er hunkøn)
p.?.= pa?ade??µat?? 
|CF802ECF872E3D20CF80CEB1CF81CEB1CEB4CEB5CEAFCEB3CEBCCEB1CF84CEBFCF8220CF87CEACCF81CEB7|f.eks.
 (for eksempel)
a???|CEB1CEBBCEBBCEAC|men
a???|CEB1CEBBCEBBCEAC|men
a???|CEB1CEBBCEBBCEAC|men
a???|CEB1CEBBCEBBCEAC|men
a???|CEB1CEBBCEBBCEAC|men
a???|CEB1CEBBCEBBCEAC|men
a???|CEB1CEBBCEBBCEAC|men
a???|CEB1CEBBCEBBCEAC|men
sqlite>

Does it tell you whats wrong?
/Lars


-Oprindelig meddelelse-
Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På 
vegne af Hick Gunter
Sendt: 13. august 2018 14:34
Til: 'SQLite mailing list'
Emne: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

Select graesk, hex(graesk), dansk from gloser;

Check the hex output to see if it conforms to UTF specs; if so, then your 
console is expecting a different encoding (probably ISO). If not, then your 
data was probably entered from a 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 
prg

Hi Hick Gunter,
I do not know exactly what you mean by this (hex())?
/Lars

-Oprindelig meddelelse-
Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På 
vegne af Hick Gunter
Sendt: 13. august 2018 14:07
Til: 'SQLite mailing list'
Emne: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

You need to show hex() before anyone can verify what encoding is 
stored.

-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im 
Auftrag von Lars Frederiksen
Gesendet: Montag, 13. August 2018 14:03
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 FILENAME" to reopen on a persistent database.
sqlite> .open flashcard.db
sqlite> select * from Gloser;
2|taß???a ?|taverna|[01_16]
3|taß???a ?|taverna|[01_16]
4|taß???a ?|taverna|[01_16]
5|taß???a ?|taverna|[01_16]
16|taß???a ?|taverna|[01_16]
17|taß???a ?|taverna|[01_16]
18|taß???a ?|taverna|[01_16]
19|de µ?? ?e?...|sig mig engang. (egl "du fortæller mig ikke")|[01_08]
20|d?µ?s?f?? ?/?|journalist|[01_08]
21|???µa t?|mønt, småmønt|[01_08]
22|??p??a ?|pige|[01_08]
23|µa??t??a ?|elev, skoleelev (kvindelig)|[01_08]
24|µa??t?? ?|elev, skoleelev (mandlig)|[01_08]
25|µp?? t?|flaske|[01_08]
26|?p??|(konj) som, ligesom, sådan som; eftersom|[01_08]
27|p?t??? t?|glas (Både glas og flaske er intetkøn som vin. Øl er
27|hunkøn)|[01_08]
28|p.?.= pa?ade??µat?? |f.eks. (for eksem

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

2018-08-13 Thread Hick Gunter

Select graesk, hex(graesk), dansk from gloser;

Check the hex output to see if it conforms to UTF specs; if so, then your 
console is expecting a different encoding (probably ISO). If not, then your 
data was probably entered from a 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 
prg

Hi Hick Gunter,
I do not know exactly what you mean by this (hex())?
/Lars

-Oprindelig meddelelse-
Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På 
vegne af Hick Gunter
Sendt: 13. august 2018 14:07
Til: 'SQLite mailing list'
Emne: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

You need to show hex() before anyone can verify what encoding is 
stored.

-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im 
Auftrag von Lars Frederiksen
Gesendet: Montag, 13. August 2018 14:03
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 FILENAME" to reopen on a persistent database.
sqlite> .open flashcard.db
sqlite> select * from Gloser;
2|taß???a ?|taverna|[01_16]
3|taß???a ?|taverna|[01_16]
4|taß???a ?|taverna|[01_16]
5|taß???a ?|taverna|[01_16]
16|taß???a ?|taverna|[01_16]
17|taß???a ?|taverna|[01_16]
18|taß???a ?|taverna|[01_16]
19|de µ?? ?e?...|sig mig engang. (egl "du fortæller mig ikke")|[01_08]
20|d?µ?s?f?? ?/?|journalist|[01_08]
21|???µa t?|mønt, småmønt|[01_08]
22|??p??a ?|pige|[01_08]
23|µa??t??a ?|elev, skoleelev (kvindelig)|[01_08]
24|µa??t?? ?|elev, skoleelev (mandlig)|[01_08]
25|µp?? t?|flaske|[01_08]
26|?p??|(konj) som, ligesom, sådan som; eftersom|[01_08]
27|p?t??? t?|glas (Både glas og flaske er intetkøn som vin. Øl er
27|hunkøn)|[01_08]
28|p.?.= pa?ade??µat?? |f.eks. (for eksempel)|[01_08]
29|taß???a ?|taverna|[01_16]
30|taß???a ?|taverna|[01_16]
31|de µ?? ?e?...|sig mig engang. (egl "du fortæller mig ikke")|[01_08]
32|d?µ?s?f?? ?/?|journalist|[01_08]
33|???µa t?|mønt, småmønt|[01_08]
34|??p??a ?|pige|[01_08]
35|µa??t??a ?|elev, skoleelev (kvindelig)|[01_08]
36|µa??t?? ?|elev, skoleelev (mandlig)|[01_08]
37|µp?? t?|flaske|[01_08]
38|?p??|(konj) som, ligesom, sådan som; eftersom|[01_08]
39|p?t??? t?|glas (Både glas og flaske er intetkøn som vin. Øl er
39|hunkøn)|[01_08]
40|p.?.= pa?ade??µat?? |f.eks. (for eksempel)|[01_08]
41|a???|men|[01_10]
42|a???|men|[01_10]
43|a???|men|[01_10]
44|a???|men|[01_10]
45|a???|men|[01_10]
46|a???|men|[01_10]
47|a???|men|[01_10]
48|a???|men|[01_10]

The second field should show greek words but only the letters that are 
identical in danish and greek is shown. The pure greek letters like β, γ, δ, ε, 
η etc are shown as questionmarks.
Do you want me to send you the database?

Best Regards
Lars

-Oprindelig meddelelse-
Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På 
vegne af Rowan Worth
Sendt: 13. august 2018 03:21
Til: SQLite mailing list
Emne: Re: [sqlite] No unicode characters in sqlite3 console prg

On 12 August 2018 at 00:51, Lars Frederiksen  wrote:

> Is this an error of my windows 10 cmd prompt or is it a general
> problem that the sqlite3 console is not able to show unicode in the
> cmd-window.??
>
> No problem writing to the database and show (greek) unicode characters
> in the cmd prompt as I key them, but when I want to show the data with
> the SQL SELECT * FROM Gloser then the greek word is shown with most of
> its letters as questionmarks.
>

What version of sqlite are you using? There was significant efforts to improve 
windows console unicode handling awhile back, which I think made it in for 
3.12/3.13.

If you're still seeing issues with a recent sqlite can you provide a short 
example which reproduces the issue?
-Rowan
___
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


___
 Gunter Hick | Software Engineer | Scientific Games International GmbH | 
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 
1 80100 - 0

May be privileged. May be confidential. Please delete if not the addressee.
___
sqlite-users mailing list
sqlite-use

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

Please run the version from this zip instead of 3.19.  You do not have to worry 
about updating the DLL libraries on your computer, since the shell tool does 
not use the DLLs.

If this does not fix your problem ...

> I do not know exactly what you mean by this (hex())?

You execute the following commands:

> sqlite> .open flashcard.db
> sqlite> select * from Gloser;
> 2|taß???a ?|taverna|[01_16]
> 3|taß???a ?|taverna|[01_16]
> 4|taß???a ?|taverna|[01_16]
> 5|taß???a ?|taverna|[01_16]

We want to know what is really in those fields.  If a column in your Gloser 
table is called "sample" the command we want would be

SELECT sample,hex(sample) FROM Gloser LIMIT 1

If you do not know what columns are in your table, please execute the following 
command

.schema Gloser

and post the results.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

2018-08-13 Thread Lars Frederiksen

Hi Hick Gunter,
I do not know exactly what you mean by this (hex())?
/Lars

-Oprindelig meddelelse-
Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På 
vegne af Hick Gunter
Sendt: 13. august 2018 14:07
Til: 'SQLite mailing list'
Emne: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

You need to show hex() before anyone can verify what encoding is 
stored.

-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im 
Auftrag von Lars Frederiksen
Gesendet: Montag, 13. August 2018 14:03
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 FILENAME" to reopen on a persistent database.
sqlite> .open flashcard.db
sqlite> select * from Gloser;
2|taß???a ?|taverna|[01_16]
3|taß???a ?|taverna|[01_16]
4|taß???a ?|taverna|[01_16]
5|taß???a ?|taverna|[01_16]
16|taß???a ?|taverna|[01_16]
17|taß???a ?|taverna|[01_16]
18|taß???a ?|taverna|[01_16]
19|de µ?? ?e?...|sig mig engang. (egl "du fortæller mig ikke")|[01_08]
20|d?µ?s?f?? ?/?|journalist|[01_08]
21|???µa t?|mønt, småmønt|[01_08]
22|??p??a ?|pige|[01_08]
23|µa??t??a ?|elev, skoleelev (kvindelig)|[01_08]
24|µa??t?? ?|elev, skoleelev (mandlig)|[01_08]
25|µp?? t?|flaske|[01_08]
26|?p??|(konj) som, ligesom, sådan som; eftersom|[01_08]
27|p?t??? t?|glas (Både glas og flaske er intetkøn som vin. Øl er
27|hunkøn)|[01_08]
28|p.?.= pa?ade??µat?? |f.eks. (for eksempel)|[01_08]
29|taß???a ?|taverna|[01_16]
30|taß???a ?|taverna|[01_16]
31|de µ?? ?e?...|sig mig engang. (egl "du fortæller mig ikke")|[01_08]
32|d?µ?s?f?? ?/?|journalist|[01_08]
33|???µa t?|mønt, småmønt|[01_08]
34|??p??a ?|pige|[01_08]
35|µa??t??a ?|elev, skoleelev (kvindelig)|[01_08]
36|µa??t?? ?|elev, skoleelev (mandlig)|[01_08]
37|µp?? t?|flaske|[01_08]
38|?p??|(konj) som, ligesom, sådan som; eftersom|[01_08]
39|p?t??? t?|glas (Både glas og flaske er intetkøn som vin. Øl er
39|hunkøn)|[01_08]
40|p.?.= pa?ade??µat?? |f.eks. (for eksempel)|[01_08]
41|a???|men|[01_10]
42|a???|men|[01_10]
43|a???|men|[01_10]
44|a???|men|[01_10]
45|a???|men|[01_10]
46|a???|men|[01_10]
47|a???|men|[01_10]
48|a???|men|[01_10]

The second field should show greek words but only the letters that are 
identical in danish and greek is shown. The pure greek letters like β, γ, δ, ε, 
η etc are shown as questionmarks.
Do you want me to send you the database?

Best Regards
Lars

-Oprindelig meddelelse-
Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På 
vegne af Rowan Worth
Sendt: 13. august 2018 03:21
Til: SQLite mailing list
Emne: Re: [sqlite] No unicode characters in sqlite3 console prg

On 12 August 2018 at 00:51, Lars Frederiksen  wrote:

> Is this an error of my windows 10 cmd prompt or is it a general
> problem that the sqlite3 console is not able to show unicode in the
> cmd-window.??
>
> No problem writing to the database and show (greek) unicode characters
> in the cmd prompt as I key them, but when I want to show the data with
> the SQL SELECT * FROM Gloser then the greek word is shown with most of
> its letters as questionmarks.
>

What version of sqlite are you using? There was significant efforts to improve 
windows console unicode handling awhile back, which I think made it in for 
3.12/3.13.

If you're still seeing issues with a recent sqlite can you provide a short 
example which reproduces the issue?
-Rowan
___
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


___
 Gunter Hick | Software Engineer | Scientific Games International GmbH | 
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 
1 80100 - 0

May be privileged. May be confidential. Please delete if not the addressee.
___
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

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

2018-08-13 Thread Hick Gunter

You need to show hex() before anyone can verify what encoding is 
stored.

-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im 
Auftrag von Lars Frederiksen
Gesendet: Montag, 13. August 2018 14:03
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 FILENAME" to reopen on a persistent database.
sqlite> .open flashcard.db
sqlite> select * from Gloser;
2|taß???a ?|taverna|[01_16]
3|taß???a ?|taverna|[01_16]
4|taß???a ?|taverna|[01_16]
5|taß???a ?|taverna|[01_16]
16|taß???a ?|taverna|[01_16]
17|taß???a ?|taverna|[01_16]
18|taß???a ?|taverna|[01_16]
19|de µ?? ?e?...|sig mig engang. (egl "du fortæller mig ikke")|[01_08]
20|d?µ?s?f?? ?/?|journalist|[01_08]
21|???µa t?|mønt, småmønt|[01_08]
22|??p??a ?|pige|[01_08]
23|µa??t??a ?|elev, skoleelev (kvindelig)|[01_08]
24|µa??t?? ?|elev, skoleelev (mandlig)|[01_08]
25|µp?? t?|flaske|[01_08]
26|?p??|(konj) som, ligesom, sådan som; eftersom|[01_08]
27|p?t??? t?|glas (Både glas og flaske er intetkøn som vin. Øl er
27|hunkøn)|[01_08]
28|p.?.= pa?ade??µat?? |f.eks. (for eksempel)|[01_08]
29|taß???a ?|taverna|[01_16]
30|taß???a ?|taverna|[01_16]
31|de µ?? ?e?...|sig mig engang. (egl "du fortæller mig ikke")|[01_08]
32|d?µ?s?f?? ?/?|journalist|[01_08]
33|???µa t?|mønt, småmønt|[01_08]
34|??p??a ?|pige|[01_08]
35|µa??t??a ?|elev, skoleelev (kvindelig)|[01_08]
36|µa??t?? ?|elev, skoleelev (mandlig)|[01_08]
37|µp?? t?|flaske|[01_08]
38|?p??|(konj) som, ligesom, sådan som; eftersom|[01_08]
39|p?t??? t?|glas (Både glas og flaske er intetkøn som vin. Øl er
39|hunkøn)|[01_08]
40|p.?.= pa?ade??µat?? |f.eks. (for eksempel)|[01_08]
41|a???|men|[01_10]
42|a???|men|[01_10]
43|a???|men|[01_10]
44|a???|men|[01_10]
45|a???|men|[01_10]
46|a???|men|[01_10]
47|a???|men|[01_10]
48|a???|men|[01_10]

The second field should show greek words but only the letters that are 
identical in danish and greek is shown. The pure greek letters like β, γ, δ, ε, 
η etc are shown as questionmarks.
Do you want me to send you the database?

Best Regards
Lars

-Oprindelig meddelelse-
Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På 
vegne af Rowan Worth
Sendt: 13. august 2018 03:21
Til: SQLite mailing list
Emne: Re: [sqlite] No unicode characters in sqlite3 console prg

On 12 August 2018 at 00:51, Lars Frederiksen  wrote:

> Is this an error of my windows 10 cmd prompt or is it a general
> problem that the sqlite3 console is not able to show unicode in the
> cmd-window.??
>
> No problem writing to the database and show (greek) unicode characters
> in the cmd prompt as I key them, but when I want to show the data with
> the SQL SELECT * FROM Gloser then the greek word is shown with most of
> its letters as questionmarks.
>

What version of sqlite are you using? There was significant efforts to improve 
windows console unicode handling awhile back, which I think made it in for 
3.12/3.13.

If you're still seeing issues with a recent sqlite can you provide a short 
example which reproduces the issue?
-Rowan
___
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


___
 Gunter Hick | Software Engineer | Scientific Games International GmbH | 
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 
1 80100 - 0

May be privileged. May be confidential. Please delete if not the addressee.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

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

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

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

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

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

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

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

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

9 matches

Site Navigation

Mail list logo

Footer information