Re: [sqlite] Where statements are they case sensitive?

I checked a few systems and there doesn't seem to be a standard. As was said Oracle is case sensitive but all the Microsoft products I check SQL, Access , MS Query where all case insensitive. I think a PRAGMA would be a great idea for this. What do other people think? Using a like

Re: [sqlite] Where statements are they case sensitive?

Hi! > 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

Re: [sqlite] Where statements are they case sensitive?

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