Re: [sqlite] sqlite-users Digest, Vol 101, Issue 25

2016-05-25 Thread lchishol
dandl wrote: > Message: 13 > Date: Wed, 25 May 2016 10:23:08 +1000 > From: "dandl" > To: "'SQLite mailing list'" > Subject: [sqlite] What could be the cause of a zero length database > file? > Message-ID:

[sqlite] CLI dump command ignores view dependencies

2014-10-01 Thread lchishol
Hi all, People on this list, and the SQLite documentation, say that the .dump command of the CLI generates SQL which can be .read to rebuild a database. What is omitted is the fact that the SQL .read may fail if you have created views referring to other views and they are output in the SQL in the

[sqlite] Automatic conversion between keywords and literals

2014-09-16 Thread lchishol
Hi all, The page http://www.sqlite.org/lang_keywords.html explains the way SQLite attempts to fix assumed misuse of single and double quotes, with the note that this (mis-)feature may go away. I would like to request a pragma or option to make it go away now :-) Although it is there for

Re: [sqlite] sqlite does not order greek characters correctly

2013-12-10 Thread lchishol
On Sun, 8 Dec 2013 21:53:51 +, Simon Slavin wrote: > > If you're not already using it, please take a look at the International > Components for Unicode: > > > > It's a compilation option. > > Simon.