Mark W. de Raad writes:
> Good afternoon,
>
> We have an not-so-unusual problem where people are accessing a database from
> different countries (in this example, Germany and the UK). One of the search
> terms commonly used is: gehäuse (housing), which the UK types in as gehause
> and Germany (rightly of course) insists the word is not valid without the
> umlaut :)
>
> I realise that I can use the german1 character set to ensure that the SORT
> order is not thrown out by the character with the umlaut - but I wish to
> have a character set insensitive SELECT so that a=ä=ae and u=ü=ue (the ue
> may be a pushing things a bit).
>
> Is there a way to do this using a character set so that a query
> automatically equates the characters as equal? Or does there need to be a
> pre-query parser implemented with a rather large [aaeä.......]?
>
> Thanks for any assistance.
>
> Regards,
>
> Mark
> ---
> Mark W. de Raad
> System Administrator
> I-Nex Corporation Pty. Ltd.
> [EMAIL PROTECTED]
Hi!
At present moment a single MySQL server supoprts one character set.
Current German set has few flaws, but a corrected version is on the
way.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php