Collations between English characters and International characters

[Andrew Nagy]

Can anyone explain how to setup a table that contains text in any 
language for searching using english characters?

Let's say I want to search for the word "Francais", but in the database 
it is stored as "Français".

Any help is appreciated
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]