Re: [sqlite] toupper/tolower

2009-06-21 Thread Zbigniew Baniewski
I'm sorry: totally missed `The "function" method' :( So, it seems, that the problem's solved. :) -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sq

Re: [sqlite] toupper/tolower

2009-06-21 Thread Zbigniew Baniewski
On Sun, Jun 21, 2009 at 08:34:23PM -0400, Igor Tandetnik wrote: > http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/icu/README.txt Yes, I've found libraries made by someone, and ready to use. Unfortunately, they are of several MB size... :( No, I would to keep the application "compact", and be

Re: [sqlite] toupper/tolower

2009-06-21 Thread Igor Tandetnik
Zbigniew Baniewski wrote: > And yes - alas - upper/lower are unable to do it properly for > characters "outside ASCII". But I've found some more info: http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/icu/README.txt Igor Tandetnik ___ sqlite-users

Re: [sqlite] toupper/tolower

2009-06-21 Thread Zbigniew Baniewski
On Sun, Jun 21, 2009 at 05:12:18PM -0700, Cory Nelson wrote: > Unfortunately, no. A correct toupper/tolower would require locale > support and passing in a string pointer, not a char. Even a wide > character can't store all the information needed to make something > upper/lower. OK, maybe diffe

Re: [sqlite] toupper/tolower

2009-06-21 Thread Cory Nelson
On Sun, Jun 21, 2009 at 4:34 PM, Zbigniew Baniewski wrote: > In the docs there is a remark: > > #v+ >  upper(X)  Return a copy of input string X converted to all upper-case >  letters. The implementation of this function uses the C library routine >  toupper() which means it may not work correctly

[sqlite] toupper/tolower

2009-06-21 Thread Zbigniew Baniewski
In the docs there is a remark: #v+ upper(X) Return a copy of input string X converted to all upper-case letters. The implementation of this function uses the C library routine toupper() which means it may not work correctly on non-ASCII UTF-8 strings. #v- And yes - alas - upper/lower are

Re: [sqlite] SQLite3 data mode for emacs?

2009-06-21 Thread Kees Nuyt
On Sun, 21 Jun 2009 12:44:51 -0700, Kelly Jones wrote: >On 6/21/09, Kees Nuyt wrote: >> On Sun, 21 Jun 2009 10:01:22 -0700, Kelly Jones >> wrote: >> >>>Emacs' "forms mode" lets you edit a text file as though each line were >>>a database record. >>> >>>Is there a similar mode that lets you edit

Re: [sqlite] SQLite3 data mode for emacs?

2009-06-21 Thread Kelly Jones
On 6/21/09, Kees Nuyt wrote: > On Sun, 21 Jun 2009 10:01:22 -0700, Kelly Jones > wrote: > >>Emacs' "forms mode" lets you edit a text file as though each line were >>a database record. >> >>Is there a similar mode that lets you edit data inside an sqlite3 db? > > Not that I know of in Emacs. There

Re: [sqlite] SQLite3 data mode for emacs?

2009-06-21 Thread Kees Nuyt
On Sun, 21 Jun 2009 10:01:22 -0700, Kelly Jones wrote: >Emacs' "forms mode" lets you edit a text file as though each line were >a database record. > >Is there a similar mode that lets you edit data inside an sqlite3 db? Not that I know of in Emacs. There are several database browsers for SQLite

[sqlite] SQLite3 data mode for emacs?

2009-06-21 Thread Kelly Jones
Emacs' "forms mode" lets you edit a text file as though each line were a database record. Is there a similar mode that lets you edit data inside an sqlite3 db? -- We're just a Bunch Of Regular Guys, a collective group that's trying to understand and assimilate technology. We feel that resistance

Re: [sqlite] Tips to access SQLite with multiple clients?

2009-06-21 Thread John Stanton
Sqlite is NOT a server, it is a library which is linked into an application. It is not a repl;acement for Oracle, DB2, PostgreSQL etc, but is a replacement for local file reads and writes. Sqlite shines embedded in applications like Firefox, various Adobe products for example. Gilles Ganau

Re: [sqlite] Tips to access SQLite with multiple clients?

2009-06-21 Thread Martin Engelschalk
Hi Gilles, first, you write of a "SQL server", but you probably know that sqlite is not a server. You can have multiple applications access a sqlite database file without problems if these applications are reading the database and not writing. If the applications also have to write, then - read

[sqlite] Tips to access SQLite with multiple clients?

2009-06-21 Thread Gilles Ganault
Hello I know that SQLite is not meant to be used by more than one simultaneous client, but I don't know of another SQL server that is so light, easy to use, and available for Linux and Windows. If you know of such a beast, I'm interested. Otherwise... I'm willing to take the risk of using

Re: [sqlite] SQLite JDBC driver performance

2009-06-21 Thread Adam Megacz
Christopher Mason writes: > [Apologies for posting this here, but the sqlitejdbc list appears to be > defunct.] Google deleted it without warning or explanation: http://www.zentus.com/sqlitejdbc/google-group-disappearance.html It has been relocated here: https://lists.hcoop.net/listinfo/

Re: [sqlite] "not an error" error inserting data trough a view on fts3 table

2009-06-21 Thread Vladimir Kharitonov
Filed the bug report here: http://www.sqlite.org/cvstrac/tktview?tn=3897 http://www.sqlite.org/cvstrac/tktview?tn=3897 Dennis Cote-2 wrote: > > Perhaps the OP should file a bug report using this example. If there is > a bug it will probably be fixed in short order. > -- View this message