[sqlite] search multiple files

2007-06-23 Thread gecko
Hi, I need to write a script that searches multiple db files (made with SQLite) for a text string. How can I do this? -- View this message in context: http://www.nabble.com/search-multiple-files-tf3971138.html#a11272075 Sent from the SQLite mailing list archive at Nabble.com.

[sqlite] Introducing... ManagedSQLite

2007-06-23 Thread WHITE, DANIEL
Howdy all! I am just writing tonight to let you know that a project of mine has opened up to being open source -- ManagedSQLite. It is a light wrapper around SQLite 3.4.0 that was originally written by Rob Groves. I have added support for Unicode to his wrapper, then added my Managed (.NET)

[sqlite] FTS2 Problem

2007-06-23 Thread WHITE, DANIEL
Hi all! I am having a problem with FTS2. Someone in the IRC channel (after I posted a bug report) said to contact here. My issue is here. Please respond asap! Thanks. http://www.sqlite.org/cvstrac/tktview?tn=2446 Daniel A. White { Kent State University: Computer Science major } { JMC

Re: [sqlite] Crashes and random wrong results with certain column names

2007-06-23 Thread Yves Goergen
On 24.06.2007 00:17 CE(S)T, Yves Goergen wrote: > CREATE TABLE "t a" ("c a", """cb"""); > (...) And this may take forever to still not finish: DROP TABLE "t a"; It then worked in a second try. -- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> Visit my web laboratory at

[sqlite] Crashes and random wrong results with certain column names

2007-06-23 Thread Yves Goergen
Hi, I've tested my own SQLite application's identifier quoting capabilities now and found that the SQLite engine has serious problems with table/column names containing certain special characters. Just try the following: CREATE TABLE "t a" ("c a", """cb"""); INSERT INTO "t a" ("c a", """cb""")

[sqlite] [Fwd: SQLite in the News]

2007-06-23 Thread Gerry Snyder
Original Message Subject: SQLite in the News Date: Sat, 23 Jun 2007 12:25:56 + From: Keith Nash <[EMAIL PROTECTED]> Organization: Customer of PlusNet plc (http://www.plus.net) Newsgroups: comp.lang.tcl Interview with Richard Hipp in The Guardian:

Re: [sqlite] Unicode collation

2007-06-23 Thread Dan Kennedy
On Sat, 2007-06-23 at 10:56 +0200, Jiri Hajek wrote: > > The reason is as you've surmised. Not all systems have full unicode > > support (I'm not sure, but if I had to guess, I would say very few > > systems do). Including an implementation with SQLite would bloat > > the library to at least

Re: [sqlite] Unicode collation

2007-06-23 Thread Jiri Hajek
The reason is as you've surmised. Not all systems have full unicode support (I'm not sure, but if I had to guess, I would say very few systems do). Including an implementation with SQLite would bloat the library to at least several times it's current size. I know really well only Windows where

Re: [sqlite] Unicode collation

2007-06-23 Thread Dan Kennedy
On Fri, 2007-06-22 at 18:57 +0200, Jiri Hajek wrote: > Hello, > > I wonder whether there are any plans to include internally proper > Unicode comparisons? Don't get me wrong, I think that it's great that > SQLite supports custom collations, there's absolutely no problem to > handle it in