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. > > > > Will it solve for all

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

2014-10-24 Thread Constantine Yannakopoulos
On Fri, Oct 24, 2014 at 9:40 AM, dd wrote: > > >>The SQLite source code includes an "ICU" extension that does these > overloads. > > Will it solve for all charsets if ICU enabled? > > ​Probably but I cannot tell for sure because I haven't used it.​ When my company started

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

2014-10-24 Thread dd
Thanks for your response. https://www.sqlite.org/faq.html#q18 >>The SQLite source code includes an "ICU" extension that does these overloads. Will it solve for all charsets if ICU enabled? On Thu, Oct 23, 2014 at 6:28 PM, Constantine Yannakopoulos < alfasud...@gmail.com> wrote: > On Thu, Oct

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

2014-10-23 Thread Constantine Yannakopoulos
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 during schema design. > > for ex: >

[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.