Re: [sqlite] Case-Sensitive Queries

2003-12-10 Thread Nuno Lucas
The problem here is all about internationalization. If you follow that route, then you are forgeting all international users of sqlite. How do you choose the locale to sort from ? I'm talking about accented characters, and diferent sorting rules. Just as an example, in spanish and french you can

[sqlite] Case-Sensitive Queries

2003-12-08 Thread Raymond Irving
Hi Everyone, I think is expedient that we look into this case-sensitive issues. I think that queries should not be case-sensitive, but if that's how things are with SQLite then I would suggest that a PRAGMA be made available to turn on/off case-sensitive queries. When searching a database the wil