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

Re: [sqlite] unique with icu

2014-10-26 Thread Simon Slavin
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. > > Is it safe to add icu for existing db's? Yes. But once you've added it and used it

Re: [sqlite] unique with icu

2014-10-26 Thread dd
Thanks Richard/Joseph. Application using sqlite database without icu extension. I am planning to add icu extension. for schema, add new column and index with lower. Is it safe to add icu for existing db's? Will it lead to any corruptions? On Sun, Oct 26, 2014 at 1:22 AM, Joseph R. Justice

Re: [sqlite] unique with icu

2014-10-25 Thread Joseph R. Justice
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. > > > > CREATE TABLE test(id integer primary key

Re: [sqlite] unique with icu

2014-10-25 Thread Richard Hipp
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. > > CREATE TABLE test(id integer primary key autoincrement, t text collate > nocase, unique(t)); > > Case 1: When I try to insert 'd' and 'D',

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 insert

[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