Re: [sqlite] [SPAM] Fwd: How to correctly display unicode characters in Windows 10 / cmd.exe / sqlite3.exe?

> Le 5 juin 2017 à 20:44, Shane Dev a écrit : > > I am already using Lucida Console font. Without chcp 65001, sqlite3.exe > will display LATIN SMALL LETTER E WITH ACUTE (U+00E9) correctly. But I > can't figure out how to display EURO SIGN (U+20AC). Lucida Console > definitely has the glyph, other

Re: [sqlite] [SPAM] Fwd: How to correctly display unicode characters in Windows 10 / cmd.exe / sqlite3.exe?

Hi David, I am already using Lucida Console font. Without chcp 65001, sqlite3.exe will display LATIN SMALL LETTER E WITH ACUTE (U+00E9) correctly. But I can't figure out how to display EURO SIGN (U+20AC). Lucida Console definitely has the glyph, otherwise my test "type utf8test.txt" would have fai

Re: [sqlite] [SPAM] Fwd: How to correctly display unicode characters in Windows 10 / cmd.exe / sqlite3.exe?

For the command prompt best I can suggest is changing the font to one of the TrueType fonts listed there like Lucida Console, then not touching the code page. Doing chcp 65001 to help, but then in some release something got added to the CLI to try and help with that automatically. With the exam

Re: [sqlite] public archive

On 5 Jun 2017, at 4:38pm, Clay Gerrard wrote: > When I find something interesting on this ML that I'd like to share with a > colleague it's often convenient to link to an online archive instead of > just forwarding a (possibly incomplete) snapshot of the thread. I recommend the use of this arch

Re: [sqlite] WAL checkpoint starved?

On 5 Jun 2017, at 1:45pm, Daniel Polski wrote: > How do I make the checkpointing work like the above documentation describes? Set a timeout. Perhaps a very long one (one minute, which is what I use in some places). You can do this two ways:

Re: [sqlite] Fwd: How to correctly display unicode characters in Windows 10 / cmd.exe / sqlite3.exe?

On 4 Jun 2017, at 9:05pm, Shane Dev wrote: > Why can't I display these Unicode characters from sqlite3 command line > utility? Windows Console doesn’t support multibyte characters: "many legacy applications cont

[sqlite] public archive

When I find something interesting on this ML that I'd like to share with a colleague it's often convenient to link to an online archive instead of just forwarding a (possibly incomplete) snapshot of the thread. It seems the "official" archive is not public? http://mailinglists.sqlite.org/cgi-bin/

Re: [sqlite] SPAM-LOW: sqlite-users Digest, Vol 114, Issue 3

I'll take a look. Thanks - Michael Condon Mission Critical Solutions (503)726-4685 Original Message > From: sqlite-users-requ...@mailinglists.sqlite.org > Sent: Saturday, June 03, 2017 5:00 AM > To: sqlite-users@mailinglists.sqlite.org > Subject: SPAM-LOW: sqlite-us

Re: [sqlite] WAL checkpoint starved?

Den 2017-06-05 kl. 12:34, skrev Richard Hipp: On 6/5/17, Daniel Polski wrote: Den 2017-06-02 kl. 16:07, skrev Richard Hipp: and I thought that SQLITE_CHECKPOINT_TRUNCATE would force the checkpoint to completion. Do you have a busy callback handler registered (https://sqlite.org/c3ref/busy_

Re: [sqlite] [PATCH] fix (a little bit more of) `.mode column` with utf-8

Yuriy M. Kaminskiy wrote: > +** Compute a utf-8 string length (in characters rather than bytes) Counting characters is an improvement. But the number of characters is not necessarily the same as the number of column positions required to display the string. If you want to handle CJK characters l

Re: [sqlite] WAL checkpoint starved?

On 6/5/17, Daniel Polski wrote: > > > Den 2017-06-02 kl. 16:07, skrev Richard Hipp: >>> >>> and I thought that SQLITE_CHECKPOINT_TRUNCATE would force the checkpoint >>> to completion. >> Do you have a busy callback handler registered >> (https://sqlite.org/c3ref/busy_handler.html) > No busy callba

[sqlite] Fwd: How to correctly display unicode characters in Windows 10 / cmd.exe / sqlite3.exe?

Hello, After logging in to Windows 10, I open a command prompt (cmd.exe) and change the code page to Unicode (UTF-8) >chcp 65001 Active code page: 65001 then I test this with a UTF-8 file - >type utf8test.txt néo66€ next I execute sqlite-tools-win32-x86-3190200\sqlite3.exe and check the encodi

[sqlite] Kaspersky detects dangerous files from the NuGet package.

Kaspersky detects dangerous files in version 1.0.105.1 of the 'System.Data.SQLite Core (x86/x64)' package published on NuGet. A concrete file in the package is '.\build\net45\x64\SQLite.Interop.dll'. The detection name is 'UDS:DangerousObject.Multi.Generic', which seems to be heuristic detection