From: Christian Stocker Date: March 23 1999 8:00am Subject: umlaute and "caseinsensitive" search. List-Archive: http://lists.mysql.com/mysql/827 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="---- =_NextPart_001_01BE7503.45EB8630" ------ =_NextPart_001_01BE7503.45EB8630 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi is there any function or whatever in mysql that umlauts (=F6=FC=E4 = etc..) are treated like letters without an umlaut, so means =E4=3Da =FC=3De = =E8=3De (not an umlaut, i know) actually, we do this a the moment the following way: if someone searches for zurich we're translating that to (within PHP) "[zZ][uU=FC=DC][rR][iI][cC]" to get an case insensititiv search with the possibility to write zurich = or z=FCrich.=20 is there an easier way to achieve that?=20 (oh yeah, the correct code for the above example is even "[zZ][uU=FC=DC=FB=FC=DC=DB][rR][iI=CF=EF][cC=E7]") furthermore we even translate the =FC=E4=F6 to ue,ae,oe, because in = german this is allowd, then our searchstring looks like this "[zZ][ue|UE|uU=FC=DC=FB=FC=DC=DB][rR][iI=CF=EF][cC=E7]" but that's certainly beyond the scope of mysql, and i have to do that = with PHP, i think chregu --- Reply-To: chregu@stripped everything else is futile... ------ =_NextPart_001_01BE7503.45EB8630--