List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:March 23 1999 8:43am
Subject:Re: umlaute and "caseinsensitive" search.
View as plain text  
On Tuesday, 1999-03-23 09:00:52 +0100, Christian Stocker wrote:
> is there any function or whatever in mysql that umlauts (öüä etc..)
> are treated like letters without an umlaut, so means ä=a ü=e è=e
> (not an umlaut, i know)

using the configure option "--with-charset=german1" when compiling
MySQL should do most of the job.  Then for normal text fields (without
the BINARY attribute) the following characters have equivalent sort
order (including upper-case):
- a à á â ã ä å æ
- c ç
- d ð
- e è é ê ë
- i ì í î ï
- n ñ
- o ò ó ô õ ö
- u ù ú û ü
- y ý

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
umlaute and "caseinsensitive" search.Christian Stocker23 Mar
  • Re: umlaute and "caseinsensitive" search.Martin Ramsch23 Mar