Re: [sqlite] using SQLite to store test-data having C.J.K.T. characters, in it?

2010-01-05 Thread Nicolas Williams
On Wed, Jan 06, 2010 at 08:21:05AM +0530, Harsha wrote: > I am developing a small testing application, which in vague way does > compare/diff etc. b/w the results obtained by executing a CLI command > under test. The output of this command may contain Asian character > such as Chinese(C),

[sqlite] using SQLite to store test-data having C.J.K.T. characters, in it?

2010-01-05 Thread Harsha
Hi All, I am developing a small testing application, which in vague way does compare/diff etc. b/w the results obtained by executing a CLI command under test. The output of this command may contain Asian character such as Chinese(C), Japanese (J), Korean (K) and Taiwanese (T). And these

Re: [sqlite] SQLite Version 3.6.22

2010-01-05 Thread Rich Shepard
On Tue, 5 Jan 2010, D. Richard Hipp wrote: > It has been our habit for the past several years to do at least one SQLite > release per month. However, we are thinking of backing off from that > schedule and releasing every other month. If we stick to this plan, it > means the next release (3.6.23)

[sqlite] SQLite Version 3.6.22

2010-01-05 Thread D. Richard Hipp
SQLite version 3.6.22 is now available on the SQLite website http://www.sqlite.org/ http://www.sqlite.org/download.html Version 3.6.22 is a bug-fix release. There are no new features. The most important changes are that two obscure bugs have been fixed. The bugs are difficult to

Re: [sqlite] Trigger Not working for SELECT criteria

2010-01-05 Thread Igor Tandetnik
Ram Mandavkar wrote: > CREATE TABLE "READMODE" ("EPC" VARCHAR(50) COLLATE NOCASE ,"COUNT" > INTEGER,"STATUS" VARCHAR) > With 2 records > 'e006',0,'0' > 'e2003412DC03011808176518',0,'0' > > // > -- > Trigger on

[sqlite] Trigger Not working for SELECT criteria

2010-01-05 Thread Ram Mandavkar
Hello All, // -- ReadMode Table // --- // CREATE TABLE "READMODE" ("EPC" VARCHAR(50) COLLATE NOCASE ,"COUNT" INTEGER,"STATUS" VARCHAR) With 2 records 'e006',0,'0' 'e2003412DC03011808176518',0,'0'

Re: [sqlite] OT: Sqliteman and its future

2010-01-05 Thread Artur Reilin
Hi Petr Vaněk, i really like the sqliteman, but there are some things that's not so great. - It seems that it don't support my databases (that are sqlite 2.8.17). I cannot open anyone of it. It says everytime, that this is probably not an database. But it is sure. - The insert of lines in

[sqlite] OT: Sqliteman and its future

2010-01-05 Thread Petr Vaněk
hi all, I'm contacting you just because I have a special proposal (read: call for help) with Sqliteman tool. What is Sqliteman Sqliteman is a developer's and/or admin's GUI tool for Sqlite3 available as opensource/gpl2. It contains the most complete feature set of all tools available -