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 map all lowercase accented words to non accented uppercase words, but others don't (like portuguese). Also there are words that don't sort in the same way as we change languages (even non accented ones - pure ASCII words). If we handle this issue in sqlite, then the databases would have to store the locale their indexes were sorted upon and maybe turning them unreadble by another sqlite application in a computer without that locale suport (or, i supose, not unreadble but with their indexes corrupted with every insert!). Maybe this is not what an embedded and compact database engine like sqlite is targeted upon. You can always do the same by using a clever user function and maybe a triger to autogenerate the sort field for the order you want (using the locale you are targeting). This is a huge subject and i'm only touching the tip of the iceberg...
My humble opinion, stick with the standard C locale sorting rules (and follow it stritcly) and maybe add some simple ways of giving the programmer the liberty to easly create those sorting fields (like leting use functions on the create statements on some fields - even that requires a new compile of the library to add the functions). As for case-sensitive/insensitive selects, all I think should be done is making sqlite understand that when we create an upper/lowercase index of a field, we want to search it in an insensitive way (upper/lowercasing the key we had given). Hope I did myself clear (I'm always in doubt as not being a native english speaker). Regards, ~Nuno Lucas === On 2003-12-08, Raymond Irving wrote === >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 will be most upset if >they did a search for "mary" and got 0 results because >they did not enter the word "Mary" > >It would be very nice if this option was available in >the next release. > >Best regards, > >-- >Raymond Irving --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
