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