[sqlite] integrity check

2014-01-09 Thread dd
Hi all, Executed integrity check for database before application starts. Sometimes, it takes 1 minute. Other times, it finishes within 2 seconds. How integrity check works? can somebody explain why it takes less time. Thanks, dd ___ sqlite-users

Re: [sqlite] integrity check

2014-01-09 Thread dd
Applied encryption on top of sqlite. Now, I suspect on encryption. Thanks for prompt response. On Thu, Jan 9, 2014 at 5:38 PM, Richard Hipp wrote: > On Thu, Jan 9, 2014 at 8:29 AM, dd wrote: > >> Hi all, >> >> Executed integrity check for database before application

[sqlite] Noticed crash on windows

2014-03-25 Thread dd
stack: ntdll!RtlEnterCriticalSection+0x12 !winMutexEnter+0x13 !sqlite3_mutex_enter+0x19 !sqlite3_step+0x5e Is it known issue with 3.7.11 on Windows. Any idea? Thanks, dd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cg

Re: [sqlite] Noticed crash on windows

2014-03-30 Thread dd
Thank you all for your inputs. Let me check. On Wed, Mar 26, 2014 at 2:05 PM, Oliver Schneider wrote: > On 2014-03-25 18:52, Larry Brasfield wrote: >> Going in, it is best to not read too much into your code running >> "pretty well" on a Unix platform. Have you run your code with >> Valgrind (or

Re: [sqlite] Improving Bulk Insert Speed (C/C++)

2014-04-02 Thread dd
Did you see any improvement if application runs with high priority(nice)? (CPU and I/O) On Thu, Apr 3, 2014 at 12:56 AM, Kevin Xu wrote: > The app seems to use between 60-80% CPU while it is running (from Activity > Monitor) while disk use (using sudo iotop -P on OSX) seem to suggest about > 20

[sqlite] detach failed with error code 1

2014-04-17 Thread dd
bove three queries in loop for 100 times for empty database (/full/path). It's throwing sqlite error 1 at some random iteration. Is it correct way to implement attach and detach dbs? Thanks, dd. ___ sqlite-users mailing list sqlite-users@sqlite

Re: [sqlite] detach failed with error code 1

2014-04-17 Thread dd
H DATABASE '/full/path/info.db' AS my_in_memory_db;] database my_in_memory_db is already in use there is a detach for every attach. What could be the solution for this? Thanks, dd On Thu, Apr 17, 2014 at 2:58 PM, Richard Hipp wrote: > Please turn on error logging (http://www.

Re: [sqlite] detach failed with error code 1

2014-04-20 Thread dd
Hipp wrote: > On Thu, Apr 17, 2014 at 9:08 AM, dd wrote: > > > Dear Richard, > > > > This is great api. > > > > output: > > > > (1) statement aborts at 5: [DETACH my_in_memory_db;] database > > my_in_memory_db is locked > > > &

Re: [sqlite] detach failed with error code 1

2014-04-30 Thread dd
, Apr 20, 2014 at 9:16 PM, Simon Slavin wrote: > > On 20 Apr 2014, at 12:58pm, dd wrote: > > > Given different database name for in-memory database for every > > iteration(looped for 1000 times). Still, it's throwing Database Locked at > > least once on Windows, no

[sqlite] Understanding Sqlite

2014-06-03 Thread dd
already there, please let me know. OR What is/are the best practice(s) to become master in sqlite in short period of time for new developers (i mean, new to sqlite not for programming)? Regards, dd ___ sqlite-users mailing list

[sqlite] How to control cpu usage while transaction in progress

2014-08-20 Thread dd
queries? (for ex: delete * from emp where empname like "%a") Thanks, dd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Will collate binary supports like query

2014-09-29 Thread dd
Hi, Needs to support case-sensitive for case-insensitive sqlite database field . To find exact case, COLLATE BINARY, works very well. What is the work around for like queries. Needs to case-sensitive for like queries and lessthan, greaterthan operators. OR Is there anyway to change

Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread dd
I just got below pragma: pragma case_sensitive_like = true On Tue, Sep 30, 2014 at 10:03 AM, dd wrote: > Hi, > > Needs to support case-sensitive for case-insensitive sqlite > database field . To find exact case, COLLATE BINARY, works very well. > > > > What is

Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread dd
@RSmith, yes. nice. Is it possible to change "collate nocase" to "collate binary" in schema for already existing db? On Tue, Sep 30, 2014 at 1:44 PM, RSmith wrote: > > On 2014/09/30 09:03, dd wrote: > >> I just got below pragma: >> pragma case

Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread dd
? Thanks. On Tue, Sep 30, 2014 at 2:09 PM, Simon Slavin wrote: > > On 30 Sep 2014, at 7:03am, dd wrote: > > > Needs to support case-sensitive for case-insensitive sqlite > > database field . To find exact case, COLLATE BINARY, works very well. > > > > > &

Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread dd
My db already there in production. I have to do it programmatically. Can it be done with any sqlite apis/pragmas. On Tue, Sep 30, 2014 at 3:19 PM, Simon Slavin wrote: > > On 30 Sep 2014, at 12:07pm, dd wrote: > > > Hi Simon, > > > >>> However, frequent use o

Re: [sqlite] Will collate binary supports like query

2014-09-30 Thread dd
Thank you :-) On Tue, Sep 30, 2014 at 3:44 PM, Simon Slavin wrote: > > On 30 Sep 2014, at 12:32pm, dd wrote: > > > My db already there in production. I have to do it programmatically. > > > > Can it be done with any sqlite apis/pragmas. > > Sure. But you do ne

Re: [sqlite] disk image malformed

2012-12-06 Thread dd
No Robert. It's on same machine -- multiple threads within process, TRUNCATE mode. On Fri, Dec 7, 2012 at 12:38 AM, Robert Myers wrote: > One thing I haven't seen anyone ask yet - are you putting this on a > network drive? > On 12/6/2012 10:52 AM, Durga D wrote: > > Hi, > > > > Is it possible

Re: [sqlite] disk image malformed

2012-12-06 Thread dd
e for some records only. There was no other errors before disk io error. I suspect, after disk io error only these errors are introduced. Any ideas? On Fri, Dec 7, 2012 at 12:39 AM, dd wrote: > No Robert. It's on same machine -- multiple threads within process, > TRUNCATE mode. >

Re: [sqlite] disk image malformed

2012-12-06 Thread dd
No. I replaced with fresh database. I want to prevent these errors in our customers place for future purpose. On Fri, Dec 7, 2012 at 1:09 AM, Simon Slavin wrote: > > On 6 Dec 2012, at 7:30pm, dd wrote: > > > My multithreaded application do all read/write operations. For each

Re: [sqlite] disk image malformed

2012-12-06 Thread dd
gt; > On 6 Dec 2012, at 7:47pm, dd wrote: > > > No. I replaced with fresh database. I want to prevent these errors in our > > customers place for future purpose. > > Run the integrity check every so often and see if the problem occurs > again. Make sure that your pr

Re: [sqlite] disk image malformed

2012-12-06 Thread dd
Databases integrity fine when application starts. These critical errors are introduced in run time. I cannot take backup of these databases also. space(memory) problem. On Fri, Dec 7, 2012 at 1:27 AM, dd wrote: > It's checking with OK, BUSY, 101 and some other errors. But not disk io,

Re: [sqlite] disk image malformed

2012-12-07 Thread dd
sizes? On Fri, Dec 7, 2012 at 2:06 AM, Simon Slavin wrote: > > On 6 Dec 2012, at 7:57pm, dd wrote: > > > It's checking with OK, BUSY, 101 and some other errors. But not disk io, > > image malformed errors. How to handle these errors in run time? these > > databases

Re: [sqlite] just a test

2012-12-08 Thread dd
Yes. Igor Tandetnik mails marked as a spam nowadays. I marked it as a NOT SPAM. On Sun, Dec 9, 2012 at 9:33 AM, Gabor Grothendieck wrote: > I am still having problems with Igor's gmail messages being marked as > spam in gmail but after the upteenth time declaring them not to be > spam google fin

Re: [sqlite] disk image malformed

2012-12-08 Thread dd
other database integrity? I am using this database for "schengen countries" customers. Can sqlite handle these characters(special)? On Fri, Dec 7, 2012 at 5:51 PM, Simon Slavin wrote: > > On 7 Dec 2012, at 1:36pm, dd wrote: > > > Thank you Simon. > > > > S

Re: [sqlite] disk image malformed

2012-12-09 Thread dd
I have code in C++. Right now, I got this issue on Mac. >>you still have faulty hardware or software faulty software means? (OS or sqlite version) On Sun, Dec 9, 2012 at 3:37 PM, Simon Slavin wrote: > > On 9 Dec 2012, at 7:34am, dd wrote: > > > I have 10 databases.

Re: [sqlite] disk image malformed

2012-12-09 Thread dd
Thank you Simon Slavin. On Sun, Dec 9, 2012 at 4:27 PM, Simon Slavin wrote: > > On 9 Dec 2012, at 12:10pm, dd wrote: > > > I have code in C++. Right now, I got this issue on Mac. > > Oh. Then you don't have to worry about Windows codepages. All your text > is al

Re: [sqlite] disk image malformed

2012-12-09 Thread dd
Can I read the database when sqlite throws disk io or image malformed or other critical errors first time. I cannot simulate these issues on my machine. So, I need your suggestion. On Sun, Dec 9, 2012 at 4:40 PM, dd wrote: > Thank you Simon Slavin. > > > On Sun, Dec 9, 2012 at 4:

Re: [sqlite] disk image malformed

2012-12-09 Thread dd
I do Integrity check every often. On Sun, Dec 9, 2012 at 5:07 PM, Simon Slavin wrote: > > On 9 Dec 2012, at 12:44pm, dd wrote: > > > Can I read the database when sqlite throws disk io or image malformed or > > other critical errors first time. I cannot simulate these iss

[sqlite] table backup

2012-12-09 Thread dd
Hi All, What is the best way to do online backup for a particular table for every write operation in a sqlite db. Not entire database. Best Regards, d ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinf

Re: [sqlite] table backup

2012-12-09 Thread dd
i mean, for every write operation in a table. On Sun, Dec 9, 2012 at 11:55 PM, dd wrote: > Hi All, > > What is the best way to do online backup for a particular table for > every write operation in a sqlite db. Not entire database. > >

Re: [sqlite] table backup

2012-12-09 Thread dd
Sometimes, sqlite databse corrupts. So, I want to take online backup of specific table. Not entire database. Any best solution? On Sun, Dec 9, 2012 at 11:29 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 09/12/12 10:35, dd wrote: > > i mea

Re: [sqlite] table backup

2012-12-10 Thread dd
> On 09/12/12 21:44, dd wrote: > > Sometimes, sqlite databse corrupts. > > That is the problem you need to fix. If you have a system that is > unreliable then it will also corrupt your backups. > > http://www.sqlite.org/lockingv3.html#how_to_corrupt > http://www.sqlite.

Re: [sqlite] table backup

2012-12-11 Thread dd
age 72 is never used Page 73 is never used Page 74 is never used Page 75 is never used Page 76 is never used Page 77 is never used Any inputs? On Tue, Dec 11, 2012 at 2:16 PM, Simon Slavin wrote: > > On 11 Dec 2012, at 7:00am, dd wrote: > > > I don't have any clue. Two

Re: [sqlite] table backup

2012-12-12 Thread dd
r the error > locally much more quickly with stack protection on then in a random system. > > > > > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dd > Sent: Tuesday, December 11, 2012 1:00 AM

Re: [sqlite] table backup

2012-12-12 Thread dd
I am using SQLite version 3.7.14.1. On Wed, Dec 12, 2012 at 2:56 PM, dd wrote: > Hi Michael > > I am using journal mode truncate. Explicitly, I am not running any pragma > for synchronous. (i think, it's default value is 2 - Full). > > Regards, > d > > &

[sqlite] like query

2013-02-25 Thread dd
Thanks in advance. Best Regards, dd. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] like query

2013-02-25 Thread dd
Thanks Richard. On Mon, Feb 25, 2013 at 6:54 PM, Richard Hipp wrote: > On Mon, Feb 25, 2013 at 9:46 AM, dd wrote: > > > Hi, > > > > Table has string data type column. format of strings: > > somedata1/somedata2/somedata3 > > > > I have written

Re: [sqlite] like query

2013-02-25 Thread dd
wrote: > > On 25 Feb 2013, at 2:46pm, dd wrote: > > > Table has string data type column. format of strings: > > somedata1/somedata2/somedata3 > > > > I have written query to search : select * from emp where column_test > like > > "somedata/%"; &g

Re: [sqlite] like query

2013-02-26 Thread dd
gt;> Igor Tandetnik wrote:> On 2/26/2013 2:39 AM, dd wrote: >> >>> SELECT * FROM emp WHERE column_test BETWEEN "somedata/" AND >>>> "somedata/zzz" >>>> >>>> This database has unicode strings(chinese/japanese/...**et

Re: [sqlite] like query

2013-02-26 Thread dd
Igor/Clemen Ladisch, >>SELECT * FROM emp WHERE column_test BETWEEN "somedata/" AND "somedata/z" I want to replace z with 10 character. But, it's failed. what is the correct decimal value for that? On Tue, Feb 26, 2013 at 6:18 PM, dd wrote: > 10 d

Re: [sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

2013-03-02 Thread dd
>>The integrity check just takes too long so we don't. pragma quick_check; doesn't take much tme. http://www.sqlite.org/pragma.html#pragma_quick_check On Sun, Mar 3, 2013 at 8:00 AM, Jason Dictos wrote: > >> . > > > > Thanks for the details. What programming language do you use? (Dropbox

[sqlite] hide sqlite database

2013-03-06 Thread dd
Hi all, Is there any flag to create sqlite database in hidden mode? (chmod, setfileattributes are os specific). I am looking for os independent. It runs on 3 major desktop oss. Thanks, dd. ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] hide sqlite database

2013-03-09 Thread dd
I have backup of existing database. I just want to hide this backup database. On Thu, Mar 7, 2013 at 5:49 PM, Clemens Ladisch wrote: > dd wrote: > > I want to hide sqlite database file. > > If you hide it, SQLite will not be able to open it. > It would be easier to ju

[sqlite] database design question

2013-06-11 Thread dd
Hi All, I am working on sample database application. I want to store book names and authors. Tables: 1. Authors: columns(AuthorId_primarykey, Name, SSN) 2. Books : columns(BookId_primarykey, Title)//Title is unique 3. Author_Books: columns(AuthorId_primarykey, BookId_primarykey) Here,

Re: [sqlite] database design question

2013-06-12 Thread dd
thor doesn't have any books. How to handle this? (I can verify in author table, whether this author belongs to any other book when book deletion. If no, delete from author table. I am not happy with this solution ) On Wed, Jun 12, 2013 at 12:37 PM, Clemens Ladisch wrote: > dd wrote: > >

Re: [sqlite] database design question

2013-06-12 Thread dd
PM, Clemens Ladisch wrote: > dd wrote: > > my app need to delete author record from author table when author > > doesn't have any books. How to handle this? (I can verify in author > > table, whether this author belongs to any other book when book > > deletion. >

Re: [sqlite] database design question

2013-06-12 Thread dd
Wed, Jun 12, 2013 at 2:01 PM, Simon Slavin wrote: > > On 12 Jun 2013, at 9:49am, dd wrote: > > >>> Book titles are not unique. > > I agree. 2. Books : columns(BookId_primarykey, > > Book_id_in_string_format_like_guid) > > I’m not sure why you

Re: [sqlite] database design question

2013-06-12 Thread dd
I got it. Thank you RSmith and Simon Slavin. On Wed, Jun 12, 2013 at 2:54 PM, Simon Slavin wrote: > > On 12 Jun 2013, at 11:14am, dd wrote: > > > Yes Simon. I am looking for it. ON DELETE RESTRICT. > > > > I got the answer. > > > > Should I enab

[sqlite] to encrypt sqlite db

2013-08-31 Thread dd
Hi All, I have to encrypt sqlite database on winrt. What are all the necessary steps to do to encrypt sqlite database? Thanks in advance. Regards, dd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] to encrypt sqlite db

2013-08-31 Thread dd
Thank you for your quick response. I am looking for freeware. If freeware not available, I have to implement encryption support for sqlite on winrt. What is the procedure to implement encryption support on winrt? Thanks, dd On Sat, Aug 31, 2013 at 6:34 PM, Stephan Beal wrote: > On Sat,

[sqlite] Any tool to create erd from sqlite database?

2013-09-20 Thread dd
I am looking for tool which generates er diagrams from existing database. Any suggetions? Thanks in advance. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] int stored as a string

2013-10-24 Thread dd
Hi, One of the column stores 'long long int' as string in database in production. Internally, sqlite maintains it as a integer or text? If Text, is there any performance overhead if I write a query based on this column? Can I get better performance If I write a query based on integer c

Re: [sqlite] int stored as a string

2013-10-24 Thread dd
like to know about how sqlite maintains emp_id column. It always contains integers in string format. On Thu, Oct 24, 2013 at 4:49 PM, Igor Tandetnik wrote: > On 10/24/2013 8:39 AM, dd wrote: >> >>One of the column stores 'long long int' as string in database in

Re: [sqlite] int stored as a string

2013-10-24 Thread dd
Igor Tandetnik wrote: > On 10/24/2013 9:46 AM, dd wrote: >> >> Sorry Igor. >> >> For ex, Employee has below columns: >> >> column details: >> 1. seq_id as integer prmary key, >> 2. emp_id as STRING >> 3. emp_mngr_id as STRING >> 4. emp_

[sqlite] Need suggestion for database scheama

2013-11-07 Thread dd
in database? Any suggestions/improvements are welcome. Thanks in advance. dd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Need suggestion for database scheama

2013-11-07 Thread dd
Thanks for pointing multimedia id, Stephan Beal. I missed it. I will ad this to my schema. On Thu, Nov 7, 2013 at 3:07 PM, Stephan Beal wrote: > On Thu, Nov 7, 2013 at 11:50 AM, dd wrote: > >> CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY >> AUTOINCREMENT,

Re: [sqlite] Need suggestion for database scheama

2013-11-07 Thread dd
It has to work with multiple devices in future. This is valid point for me. Thanks. On Thu, Nov 7, 2013 at 3:42 PM, Stephan Beal wrote: > On Thu, Nov 7, 2013 at 12:15 PM, dd wrote: > >> Thanks for pointing multimedia id, Stephan Beal. I missed it. I will >> ad this to my

[sqlite] tools list from sqlite.org

2013-11-07 Thread dd
Hi, I used to include sqlite3.h/c files (from amalgamation) in application. I would like to know about tools from sqlite.org. What are all the tools available from sqlite.org? Where can I find the list of tools/utilities? any document? Thanks. ___

Re: [sqlite] Need suggestion for database scheama

2013-11-09 Thread dd
#x27; and add plural for track/album. Thanks for suggestions. dd On Fri, Nov 8, 2013 at 7:47 AM, James K. Lowden wrote: > On Thu, 7 Nov 2013 14:50:44 +0400 > dd wrote: > >> I am working on sqlite database schema for Music/Track files. I am >> posting few tables schema her

[sqlite] executing queries on normalized database

2013-11-10 Thread dd
Hi, I have two tables in my database. After applying normalization, there are twelve tables with foreign key support. For insert/delete operations, it has to execute twelve queries instead of two. Is it recommended way? In delete case, do always need to check in parent table whether chi

Re: [sqlite] executing queries on normalized database

2013-11-11 Thread dd
ON UPDATE CASCADE ON DELETE CASCADE); How do I insert trackname as "That's Amore" and artistname as "Dean Martin" with single query in artist and track tables? dd On Sun, Nov 10, 2013 at 6:45 PM, Simon Slavin wrote: > > On 10 Nov 2013, at 10:54am, dd wrote

Re: [sqlite] executing queries on normalized database

2013-11-11 Thread dd
ack. For first track to four tracks, it should not delete artist information from artist table. For fifth track, it should delete track information along with artist information. Is it possible to do with single query? On Mon, Nov 11, 2013 at 3:08 PM, dd wrote: > Hi, > > Thanks Si

Re: [sqlite] executing queries on normalized database

2013-11-11 Thread dd
Got it. Can I conclude this way: Foreign keys works pretty well when application deals with parent keys only. But, application may need to execute more queries when dealing with child key/tables. Is it? Thanks, dd On Mon, Nov 11, 2013 at 5:35 PM, Simon Slavin wrote: > > On 11 Nov 2013,

[sqlite] how to store latin strings with no casae

2014-10-23 Thread dd
Hi, database schema defined with collate nocase. It supports only for ascii (upper and lower). If I want to support db for other characters with nocase, what steps I need to consider during schema design. for ex: *À Á Â Ã Ä Å Æ = * * à á â ã ä å æ * Thanks.

Re: [sqlite] how to store latin strings with no casae

2014-10-23 Thread dd
wrote: > On Thu, Oct 23, 2014 at 2:47 PM, dd wrote: > > > Hi, > > > > database schema defined with collate nocase. It supports only for ascii > > (upper and lower). If I want to support db for other characters with > > nocase, what steps I need to consider du

[sqlite] unicode case insensitive

2014-10-24 Thread dd
QUE constraint failed: test.t sqlite> .headers on sqlite> select * from test; id|t 1|a sqlite> insert into test(t) values('ö'); sqlite> insert into test(t) values('Ö');//issue: allowed to insert. Expects constraint failed e

Re: [sqlite] unicode case insensitive

2014-10-24 Thread dd
t up, > but straightforward. > > Gerry > > > > On 10/24/2014 9:54 AM, dd wrote: > >> Hi, >> >> ö and Ö same character but case different. I dont want to allow to insert >> two entries for same data with different case. It works well with ascii >>

Re: [sqlite] how to store latin strings with no casae

2014-10-24 Thread dd
Thank you. On Fri, Oct 24, 2014 at 11:24 PM, Constantine Yannakopoulos < alfasud...@gmail.com> wrote: > On Fri, Oct 24, 2014 at 9:40 AM, dd wrote: > > > > > >>The SQLite source code includes an "ICU" extension that does these > > overloads. > &g

Re: [sqlite] unicode case insensitive

2014-10-24 Thread dd
oint which option is suitable for my requirement. On Fri, Oct 24, 2014 at 11:51 PM, James K. Lowden wrote: > On Fri, 24 Oct 2014 21:44:50 +0400 > dd wrote: > > > >>Convert everything to upper (or lower) case brute force. > >Sorry. I am not clear. C

Re: [sqlite] unicode case insensitive

2014-10-24 Thread dd
typo: *I am summarizing options to support unicode* case-insensitive*: On Sat, Oct 25, 2014 at 10:34 AM, dd wrote: > I am summarizing options to support unicode case-sensitive: > > 1. Richard Hipp: icu ext > 2. Aleksey Tulinov: https://bitbucket.org/alekseyt/nunicode#markdown- >

[sqlite] How to enable icu for sqlite shell

2014-10-25 Thread dd
Hi, I need to verify unicode stuff with shell. Is it possible? Tried with .load icu, thrown "icu.so cannot open...". Where can I find icu.so on sqlite.org? Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bi

[sqlite] unique with icu

2014-10-25 Thread dd
Hi, icu enabled for sqlite. I didn't do any custom collations/like operator. CREATE TABLE test(id integer primary key autoincrement, t text collate nocase, unique(t)); Case 1: When I try to insert 'd' and 'D', throwing constraint violation. (SUCCESS) Case 2: When I try to insert 'ö' and 'Ö'

Re: [sqlite] unique with icu

2014-10-25 Thread dd
any inputs. On Sat, Oct 25, 2014 at 3:09 PM, dd wrote: > Hi, > > icu enabled for sqlite. I didn't do any custom collations/like operator. > > CREATE TABLE test(id integer primary key autoincrement, t text collate > nocase, unique(t)); > > Case 1: When I try to

Re: [sqlite] unique with icu

2014-10-25 Thread dd
stice wrote: > On Sat, Oct 25, 2014 at 3:44 PM, Richard Hipp wrote: > > > On Sat, Oct 25, 2014 at 7:09 AM, dd wrote: > > > > > > > Hi, > > > > > > icu enabled for sqlite. I didn't do any custom collations/like > > operator. > &g

Re: [sqlite] unique with icu

2014-10-26 Thread dd
Thanks a million Simon :-) On Sun, Oct 26, 2014 at 8:11 PM, Simon Slavin wrote: > > On 26 Oct 2014, at 6:00am, dd wrote: > > > Application using sqlite database without icu extension. I am planning to > > add icu extension. for schema, add new column and index with lower.