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 PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7