From: Martin Ramsch
Date: March 23 1999 8:43am
Subject: Re: umlaute and "caseinsensitive" search.
List-Archive: http://lists.mysql.com/mysql/828
Message-Id: <19990323094328.A26140@forwiss.uni-passau.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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