Hello. On Sat 2002-12-07 at 04:04:04 +0000, [EMAIL PROTECTED] wrote: > Hi folks. > > I have an application in which I require the only case equivalencies > to be a-z A-Z. What I mean is, e/E should be regarded as identical > in strings, but neither e/É (E-acute) nor é (e-acute)/É (E-acute) > should be regarded as identical.
What you want is looking into changing the "charset" to something appropriate. "usa7" sounds as if it should work. Depending on your MySQL version you can do this on a per-table basis (v4.0) or only globally (in my.cnf). HTH, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php