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
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
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
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
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.
___
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,
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
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
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
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
> 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
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
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:
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
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
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
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
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-
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
> 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
> 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
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
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
23 matches
Mail list logo