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]
---------------------------------------------------------------------
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