[sqlite] problem on Windows using filenames with non-ASCII characters

2016-02-07 Thread Teg
Hello Holger, The question is how does Sqlite.exe see the passed in filename? One thing you can do is use "procmon" and watch the filename of the file Sqlite.exe is trying to open. That'll probably give you a clue as to where the conversion is going wrong. This is what procmon told me: 11:30:46

[sqlite] problem on Windows using filenames with non-ASCII characters

2016-02-07 Thread Holger Jakobs
plausibolo.de USt-Id: DE288331926 -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 181 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160207/61545339/attachment.pgp>

[sqlite] problem on Windows using filenames with non-ASCII characters

2016-02-07 Thread Simon Slavin
On 7 Feb 2016, at 9:46pm, Holger Jakobs wrote: > Unfortunately, it doesn't help. > > see http://plausibolo.de/tmp/utf8_cmd.png > > Codepage ist 65001 (UTF-8), there already was a db called > 103_Beethovenstra?e_Stammdaten.etv; trying to open it creates a new one > called 103_Beethovenstra?e_St

[sqlite] User-defined types -- in Andl

2016-02-07 Thread da...@andl.org
Andl does contain an Sudoku solver, far shorter than Pasma's. See http://www.andl.org/2015/06/recursive-queries-sudoku-solver/. Regards David M Bennett FACS Andl - A New Database Language - andl.org -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-us

[sqlite] Andl update

2016-02-07 Thread da...@andl.org
Just a note to say that Andl continues to move forward. Recent posts include a Thrift interface, Workbench and new syntax. Relevance: Andl is tightly integrated with Sqlite, and provides an alternative query language to SQL. Posts are here http://www.andl.org/posts/. Let me know if you have any q

[sqlite] problem on Windows using filenames with non-ASCII characters

2016-02-07 Thread Holger Jakobs
-- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 181 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160207/3ae1dca2/attachment.pgp>

[sqlite] problem on Windows using filenames with non-ASCII characters

2016-02-07 Thread Holger Jakobs
Hello! When trying to open a db file with a name containing non-ASCII characters on Windows, I get an error that the file couldn't be found. Actually, the error message doesn't contain the character itself, because it gets changed by the sqlite3.exe program. The file name I tried contains the let

[sqlite] problem on Windows using filenames with non-ASCII characters

2016-02-07 Thread Simon Slavin
On 7 Feb 2016, at 7:39pm, Holger Jakobs wrote: > I'm using sqlite3.exe from the command line in a DOS window and pass the > file name as a parameter. I know little about Windows 10 but I suspect that you have a non-UTF code page set for command.exe. Could you check the configuration of the sh

[sqlite] Use of __builtin_expect in SQLite

2016-02-07 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/02/16 00:56, Dominique Pell? wrote: > I'm curious about the outcome on SQLite benchmarks. About a year ago I tried them out on some tight code (non-SQLite) that absolutely had to use less CPU time. I couldn't get them to make any difference out

[sqlite] problem on Windows using filenames with non-ASCII characters

2016-02-07 Thread Simon Slavin
On 7 Feb 2016, at 7:09pm, Holger Jakobs wrote: > The file name I tried contains the letter '?', but umlauts like ?? > cause the same trouble. > > On Linux everything is fine. Since other programs, like tclsh or wish > from the Tcl/Tk suite, have not problem, I wonder whether sqlite3.exe > h

[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-02-07 Thread Simon Slavin
On 7 Feb 2016, at 1:51pm, Bernard McNeill wrote: > Is it correct to say that, under Linux, if SQLITE_EXTRA_DURABLE is set (and > all other settings are left as default values), and with the further > assumption that the hardware > reports write status accurately to the OS, then SQLITE_OK will on

[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-02-07 Thread Bernard McNeill
=== https://www.sqlite.org/src/timeline?y=ci&c=af92401826f5cf49e62c === To clarify: Is it correct to say that, under Linux, if SQLITE_EXTRA_DURABLE is set (and all other settings are left as default values), and with the further assumption that the hardware reports write status accurately to t

[sqlite] Use of __builtin_expect in SQLite

2016-02-07 Thread Dominique Pellé
Hi I see that SQLite has many small optimizations being checked-in. Wouldn't it help to use the following macros and use unlikely(...) for error paths: #ifdef __GNUC__ #define likely(x) __builtin_expect(!!(x), 1) #define unlikely(x) __builtin_expect(!!(x), 0) #else #define likely(x)