I agree with Greg, the most irksome feature of SQLite is the case sensititvity - it's one of the few things MS got right with SQLserver. I know this is more mainstream/standard SQL behaviour but it's outdated in modern SQL applications that nearly always do some kind of linguistic searching. In fact, I'd go one step further and advocate making SQLite case-insensitive as a rule. I'm waiting for the flames....... Steve
As a second reply to this ...
Presumably what case-insensitive supporters really want is a system which preserves multiple cases on insert, but matches or sorts insensitively.
As far as I'm concerned, this is strictly an INDEXING matter. If SQLite has a customization mechanism where you can define how each index works (eg: the hashing function for the index) then we can define for ourselves whether it works on a case-sensitive or insensitive or some other way.
On that note, isn't this what the custom collation functions are for?
Of course, if case preservation isn't important, the application/wrapper could just uppercase everything on insert or search.
-- Darren Duncan
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
