Re: [sqlite] sqlite-users Digest, Vol 2, Issue 24

I am interested to join in this [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, February 10, 2008 10:30 PM To: sqlite-users@sqlite.org Subject: sqlite-users Digest, Vol 2, Issue 24 Send sqlite-users mailin

[sqlite] FW: sqlite-users Digest, Vol 2, Issue 24

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, February 10, 2008 10:30 PM To: sqlite-users@sqlite.org Subject: sqlite-users Digest, Vol 2, Issue 24 Send sqlite-users mailing list submissions to sqlite-users@sqlite

[sqlite] Trace

Hi , I am working in 3.3.6. If I want to use the "TRACE" what steps I have to follow. Thanks & Regards, Mahalakshmi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Serious problem: lower/upper malfunction

As I understand it, sqlite upper and lower functions only work on ASCII. There is an icu extension to make it work with UTF-8/UTF-16 as far as I know. Cheers, Shawn 2008/2/10 Zbigniew Baniewski <[EMAIL PROTECTED]>: > #v+ > SQLite version 3.5.4 > Enter ".help" for instructions > sqlite> selec

[sqlite] Serious problem: lower/upper malfunction

#v+ SQLite version 3.5.4 Enter ".help" for instructions sqlite> select lower(A); SQL error: no such column: A sqlite> select lower('A'); a sqlite> select lower('Ą'); Ą sqlite> select lower('ŻŹĆ'); ŻŹĆ sqlite> select upper('ążźć'); ążźć sqlite> select upper('asdf'); ASDF #v- As one can see, the low

Re: [sqlite] May one software write to the SQLite database while a other read the same SQLite database ?

We are usually in situation that two processes requiring database access work at the same time. Any of them can impose implicit lock updating database. Does it mean that in such scenario we must use sqlite3_busy_timeout() in front of each database access call to manage a better way concurrent work