Re: [sqlite] Case-sensitivity, performance and LIKE

2010-03-31 Thread Simon Slavin
On 1 Apr 2010, at 2:55am, Rashed Iqbal wrote: > Thank you, all for your responses. I did not have access to table > definition so I used collate no-case within statements. However, I still > have very slow performance of the DB. If you are using a different collation to the one the column is def

Re: [sqlite] Case-sensitivity, performance and LIKE

2010-03-31 Thread Rashed Iqbal
! ~r -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jay A. Kreibich Sent: Tuesday, March 30, 2010 8:13 PM To: Tom Holden Cc: General Discussion of SQLite Database Subject: Re: [sqlite] Case-sensitivity, performance and LIKE On Tue, M

Re: [sqlite] Case-sensitivity, performance and LIKE

2010-03-30 Thread Jay A. Kreibich
On Tue, Mar 30, 2010 at 10:59:49PM -0400, Tom Holden scratched on the wall: > > - Original Message - From: "Jay A. Kreibich" > To: "General Discussion of SQLite Database" > Sent: Tuesday, March 30, 2010 9:26 PM > Subject: Re: [sqlite] Case-sensitivity,

Re: [sqlite] Case-sensitivity, performance and LIKE

2010-03-30 Thread Tom Holden
- Original Message - From: "Jay A. Kreibich" To: "General Discussion of SQLite Database" Sent: Tuesday, March 30, 2010 9:26 PM Subject: Re: [sqlite] Case-sensitivity, performance and LIKE > On Tue, Mar 30, 2010 at 08:41:09PM -0400, Tom Holden s

Re: [sqlite] Case-sensitivity, performance and LIKE

2010-03-30 Thread Jay A. Kreibich
On Tue, Mar 30, 2010 at 08:41:09PM -0400, Tom Holden scratched on the wall: > > - Original Message - > From: "Simon Slavin" > > columnName TEXT COLLATE NOCASE > > > > then all sorting and SELECT queries on it will ignore case. > > You don't even have to change the defined collation as y

Re: [sqlite] Case-sensitivity, performance and LIKE

2010-03-30 Thread Tom Holden
- Original Message - From: "Simon Slavin" To: "General Discussion of SQLite Database" Sent: Tuesday, March 30, 2010 8:12 PM Subject: Re: [sqlite] Case-sensitivity, performance and LIKE > > On 31 Mar 2010, at 12:51am, Rashed Iqbal wrote: > >> Is ther

Re: [sqlite] Case-sensitivity, performance and LIKE

2010-03-30 Thread Simon Slavin
On 31 Mar 2010, at 12:51am, Rashed Iqbal wrote: > Is there a way to make SQLite queries case-insensitive? > > For example my query is: > > SELECT * from Customers WHERE LastName = 'Shaw' AND FirstName = 'Gioia' > > and I want to be able to get same results no matter if the case is good > in

[sqlite] Case-sensitivity, performance and LIKE

2010-03-30 Thread Rashed Iqbal
Hello, I need help with the following question: Is there a way to make SQLite queries case-insensitive? For example my query is: SELECT * from Customers WHERE LastName = 'Shaw' AND FirstName = 'Gioia' and I want to be able to get same results no matter if the case is good in the D