date:20180813

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

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 can verify what encoding is 
stored.

-Ursprüngl

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

2018-08-13 Thread Olivier Mascia

> Le 13 août 2018 à 14:22, Lars Frederiksen  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

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|taß???a ?|taverna|[01_16]
17|taß???a ?|taverna|[01_16]
18

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 eksempel)|[01_08]
29|taß???a ?|taverna|[01_16]
30|taß???a ?|taverna|[01

Re: [sqlite] Using Chinook

2018-08-13 Thread Chris Locke

> I am just starting to learn SQLite

Just a nod to check out (if you haven't already) the tutorials on w3schools.
https://www.w3schools.com/sql/default.asp

Not only do they clearly explain various SQL commands, but you can try them
out 'live' on their website using sample databases - nothing to install.


Thanks,
Chris


On Mon, Aug 13, 2018 at 1:15 PM Roger Schlueter  wrote:

> I am just starting to learn SQLite so I am afraid my questions here will
> be quite simple for a (very long?) while compared to those I have been
> reading.  I'm starting by trying to follow the tutorial.
>
> I have SQLite, the GUI, and chinook.db installed on Windows 10 but not
> in the default directories.  In the cmd window I have this:
>
> C:\Program Files\SQLite>sqlite3 e:\"VB Resources"\SQLite\chinook.db
> Error: unable to open database "e:"VB": unable to open database file
>
> It appears that SQLite does not like directory names with embedded
> blanks.  Is that correct?  If so, is there a workaround?
>
> Roger
>
> ___
> 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

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-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/list

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] Using Chinook

2018-08-13 Thread Chris Locke

When using directories with spaces, its better (or necessary) to include
the whole directory in double quotes.  Therefore, try entering this:
sqlite3 "e:\VB Resources\SQLite\chinook.db"

No problems with being a novice - everyone was a novice once.

Thanks,
Chris

On Mon, Aug 13, 2018 at 1:15 PM Roger Schlueter  wrote:

> I am just starting to learn SQLite so I am afraid my questions here will
> be quite simple for a (very long?) while compared to those I have been
> reading.  I'm starting by trying to follow the tutorial.
>
> I have SQLite, the GUI, and chinook.db installed on Windows 10 but not
> in the default directories.  In the cmd window I have this:
>
> C:\Program Files\SQLite>sqlite3 e:\"VB Resources"\SQLite\chinook.db
> Error: unable to open database "e:"VB": unable to open database file
>
> It appears that SQLite does not like directory names with embedded
> blanks.  Is that correct?  If so, is there a workaround?
>
> Roger
>
> ___
> 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] Using Chinook

2018-08-13 Thread Chris Locke

> to include the whole directory

Sorry, I meant the whole filename.

On Mon, Aug 13, 2018 at 1:28 PM Chris Locke 
wrote:

> When using directories with spaces, its better (or necessary) to include
> the whole directory in double quotes.  Therefore, try entering this:
> sqlite3 "e:\VB Resources\SQLite\chinook.db"
>
> No problems with being a novice - everyone was a novice once.
>
> Thanks,
> Chris
>
> On Mon, Aug 13, 2018 at 1:15 PM Roger Schlueter  wrote:
>
>> I am just starting to learn SQLite so I am afraid my questions here will
>> be quite simple for a (very long?) while compared to those I have been
>> reading.  I'm starting by trying to follow the tutorial.
>>
>> I have SQLite, the GUI, and chinook.db installed on Windows 10 but not
>> in the default directories.  In the cmd window I have this:
>>
>> C:\Program Files\SQLite>sqlite3 e:\"VB Resources"\SQLite\chinook.db
>> Error: unable to open database "e:"VB": unable to open database file
>>
>> It appears that SQLite does not like directory names with embedded
>> blanks.  Is that correct?  If so, is there a workaround?
>>
>> Roger
>>
>> ___
>> 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] Using Chinook

2018-08-13 Thread Richard Hipp

On 8/13/18, Roger Schlueter  wrote:
> It appears that SQLite does not like directory names with embedded
> blanks.  Is that correct?

Incorrect.

I do not know why your command is not working.  Perhaps your
command-line process is expecting the entire filename to be quoted,
rather than just the one directory that has a space in its name:

sqlite3 "e:\VB Resources\SQLite\chinook.db"

But your original command worked fine for me on Win10.  So I don't
know what the problem is.

-- 
D. Richard Hipp
d...@sqlite.org
___
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] No unicode characters in sqlite3 console prg

2018-08-13 Thread Lars Frederiksen

Hi Simon,

I use Windows 10 and have tried 
chcp 65001
without any luck. Still the same questionmarks
/Lars


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

On 13 Aug 2018, at 1:03pm, Lars Frederiksen  wrote:

> I use versio 3.19

What operating system ?

If you are using Windows, please issue this command before using sqlite3.exe:

chcp 65001

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

[sqlite] Using Chinook

2018-08-13 Thread Roger Schlueter

I am just starting to learn SQLite so I am afraid my questions here will 
be quite simple for a (very long?) while compared to those I have been 
reading.  I'm starting by trying to follow the tutorial.


I have SQLite, the GUI, and chinook.db installed on Windows 10 but not 
in the default directories.  In the cmd window I have this:


C:\Program Files\SQLite>sqlite3 e:\"VB Resources"\SQLite\chinook.db
Error: unable to open database "e:"VB": unable to open database file

It appears that SQLite does not like directory names with embedded 
blanks.  Is that correct?  If so, is there a workaround?


Roger

___
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] No unicode characters in sqlite3 console prg

2018-08-13 Thread Simon Slavin

On 13 Aug 2018, at 1:03pm, Lars Frederiksen  wrote:

> I use versio 3.19

What operating system ?

If you are using Windows, please issue this command before using sqlite3.exe:

chcp 65001

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

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

2018-08-13 Thread Lars Frederiksen

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

Re: [sqlite] SQLITE Porting on FreeRTOS with STM32

2018-08-13 Thread Richard Hipp

On 8/13/18, Wei  wrote:
> I want to port on stm32 with sqlite.
> But I get the followings:
> .\RTOSDemo.axf: Error: L6218E: Undefined symbol sqlite3_os_end (referred
> from sqlite3.o).
> .\RTOSDemo.axf: Error: L6218E: Undefined symbol sqlite3_os_init (referred
> from sqlite3.o).

The sqlite3_os_init() routine is called by SQLite to initialize the
default VFSes for your system.  sqlite3_os_end()  undoes the
initialization.  If you use SQLITE_OS_OTHER, then you need to supply
these two routines.  If your VFS has no initialization requirements,
you can simply create stub routines that return without doing
anything.

See the source code for how these routines are implemented for Unix and Windows.

>
>
> 1.download the latest sqlite3(3.24.0),copy sqlite3.c and sqlite3.h to my
> project.
> 2.added the sqlite3.c file to the project. Obviously, sqlite3.h has to be
> there too. Had to add three defines (SQLITE_THREADSAFE=0 SQLITE_OS_OTHER=1
> SQLITE_OMIT_WAL=1) to make it compile
> 3.However I change the defines, I can't compile through.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE Porting on FreeRTOS with STM32

2018-08-13 Thread Wei

I want to port on stm32 with sqlite.
But I get the followings:
.\RTOSDemo.axf: Error: L6218E: Undefined symbol sqlite3_os_end (referred from 
sqlite3.o).
.\RTOSDemo.axf: Error: L6218E: Undefined symbol sqlite3_os_init (referred from 
sqlite3.o).


1.download the latest sqlite3(3.24.0),copy sqlite3.c and sqlite3.h to my 
project.
2.added the sqlite3.c file to the project. Obviously, sqlite3.h has to be there 
too. Had to add three defines (SQLITE_THREADSAFE=0 SQLITE_OS_OTHER=1 
SQLITE_OMIT_WAL=1) to make it compile
3.However I change the defines, I can't compile through.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Consistent Crash in Page Cache

2018-08-13 Thread Ashish Goyal

Hi,
  We are facing consistent crash in SQLite Linux while freeing the Page
Cache when WAL-index has changed. Here is the stack trace:

#0  0x003c000325e5 in raise ()
#1  0x003c00033dc5 in abort ()
#2  0x003c000704f7 in __libc_message ()
#3  0x003c00075f3e in malloc_printerr ()
#4  0x003c00078d8d in _int_free ()
#5  0x0058ed12 in sqlite3MemFree (pPrior=0x7fb13e7aa500) at
sqlite3.c:20817
#6  0x0058facf in sqlite3_free (p=0x7fb13e7aa500) at sqlite3.c:24674
#7  0x0059d44b in pcache1Free (p=0x7fb13e7aa500) at sqlite3.c:45379
#8  0x0059d5a4 in pcache1FreePage (p=0x7fb13e7ac5b8) at
sqlite3.c:45463
#9  0x0059d9d4 in pcache1TruncateUnsafe (pCache=0x7fb46800ee58,
iLimit=1) at sqlite3.c:45668
#10 0x0059e2a4 in pcache1Truncate (p=0x7fb46800ee58, iLimit=1) at
sqlite3.c:46138
#11 0x0059cb69 in sqlite3PcacheTruncate (pCache=0x7fb46802ec68,
pgno=0) at sqlite3.c:44797
#13 0x0059f8e0 in pager_reset (pPager=0x7fb46802eb38) at
sqlite3.c:48649
#14 0x005a1070 in pagerBeginReadTransaction (pPager=0x7fb46802eb38)
at sqlite3.c:50140
#15 0x005a338e in sqlite3PagerSharedLock (pPager=0x7fb46802eb38) at
sqlite3.c:52225
#16 0x005ad150 in lockBtree (pBt=0x7fb46802e678) at sqlite3.c:61943
#17 0x005ad940 in sqlite3BtreeBeginTrans (p=0x7fb46802e618,
wrflag=0) at sqlite3.c:62308
#18 0x005c90af in sqlite3VdbeExec (p=0x7fb46803a148) at
sqlite3.c:81523
#19 0x005c27b0 in sqlite3Step (p=0x7fb46803a148) at sqlite3.c:76699

The crash generally happens when core is very large more than 14 GB. Is
this due to high memory usage of process or system running out of memory.

There is only one reference to this stack where there were some memory
issue.

Any pointers would be useful.


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

[sqlite] Either bad constant or bad comment in os_unix.c

2018-08-13 Thread Shevek


In the nolock IOMETHODS:

https://github.com/mackyle/sqlite/blob/7bd4fc81a71bdc777151c747b2e6d3ee58994251/src/os_unix.c#L5203

Either the constant should be '1' or the comment should permit mmap. I 
suspect the constant should be 1?


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

Re: [sqlite] mmap, madvise, mlock and performance

2018-08-13 Thread Shevek


On 08/03/2018 12:55 PM, Simon Slavin wrote:

On 3 Aug 2018, at 8:36pm, Shevek  wrote:


We are running a 100Gb sqlite database, which we mmap entirely into RAM. We are 
having trouble with parts of the disk file being evicted from RAM during 
periods of low activity causing slow responses, particularly before 9am. Has 
anybody played with mlock and/or madvise within the sqlite mmap subsystem to 
improve this behaviour?


Is this a genuine Linux machine running on physical hardware, or is it a 
virtual machine ?


Yes, it's a genuine physical, we have Xeon and Epyc CPUs available. 
Sometimes we have to run in VMs (up to 50Gb), but the bigger stuff is 
all physical. We typically have 256Gb+ of RAM, so we aren't under 
particular pressure to mmap a 100Gb database.



Are you intentionally doing anything that would contend for this memory ?  In 
other words, when a memory-mapped portion gets swapped out, does it make sense 
what replaced it, or is it pointless and weird ?


Sometimes, Linux just seems to get unfriendly with a set of pages and 
just maps them out. I've been watching it all weekend - right now the 
system I'm watching has 165Gb free, and I watched Linux just dump 40Gb 
out of RAM. :-( There are other jobs running on the system, and doing 
I/O, but nothing that should put any real memory pressure on the system, 
aside from disk I/O, backup, etc.


We're about to try mlockall(MCL_FUTURE) along with MAP_SHARED. It might 
also be worth trying fadvise(), but I think kernel only honours a few 
megabytes based on that. We did think of a page-toucher thread but that 
risks thrashing as much as anything, but might be interesting for 
monitoring page faults performance.


Later note: mlockall() failed because of JVM heap; we're going to have 
to do something much more specific, like holding a secondary map and 
mlocking that.


Warren:

Is the copy-everything-into-memory strategy not prohibitively expensive 
at the 100+Gb scale? Is it worth sinking the time into implementing 
that? Our rows are very small, only a few bytes each, so the per-row 
overhead may be significant. Also, it would be nice to have a shared 
mmap, rather than entirely private RAM, so we can run experiments over 
the shared (readonly) store.


S.
___
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] 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] Using Chinook

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

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

Re: [sqlite] Using Chinook

Re: [sqlite] Using Chinook

Re: [sqlite] Using Chinook

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

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

[sqlite] Using Chinook

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

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

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

Re: [sqlite] SQLITE Porting on FreeRTOS with STM32

[sqlite] SQLITE Porting on FreeRTOS with STM32

[sqlite] Consistent Crash in Page Cache

[sqlite] Either bad constant or bad comment in os_unix.c

Re: [sqlite] mmap, madvise, mlock and performance

23 matches

Site Navigation

Mail list logo

Footer information