I just checked something and noticed that the WHERE statement is case sensitive. I have check this in SQL Server and it is not case sensitive.
I am using 2.8.5 and 2.8.6.
As an example in the northwind DB I have for SQLite . There is a table called Orders
select * from sqlite_master where Name = 'orders' return no rows but
select * from sqlite_master where Name = 'Orders' does return rows
but
create table orders(a) returns an error with the table already exists.
Should the where statement be case sensitive , By default I don't think it should.
Should I report a bug on this or was it by design??
I think MS SQL Server is the odd one out here. Oracle is case sensitive by default, as are many others.
Personally, I'd like a pragma or something to make index searches case insensitive, but I get by by forcing all case insensitive search fields to upper case when storing to the database and when doing the search.
(You can do case insensitive searches by using "field like 'xyz'" instead of "field='xyz'" or "upper(field)='XYZ'", but these won't use the indices, so it'd be nice to be able to set the case sensitivity of indices individually)
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
