Is there a way to sort case-insensitively without using LOWER()?
I thought that a combination of encoding and LC_COLLATE would achieve
this, but everything I've tried so far has resulted in the dreaded
caps-come-first(tm) behavior.
A setting in the DB to force text fields to be sorted case insensitively
would do a lot to simplify parts of our application.
--
Bill Moran
http://www.potentialtech.comhttp://people.collaborativefusion.com/~wmoran/