Hello
Does anyone know if MySQL 5.0 has any multi lingual support?
I have a table that stores people names.
If the user is working in English that all the names in the table will be in English. However, if the user works in French than the table will contain French names, etc.
I would like to be able to ask MySQL to display the names sorted, however a lexical sort is not sufficient as different languages have different rules when it comes to sorting textual content in their language.
Does anyone know if MySQL support what I want?
I am looking for string comparison using collating information.
C support this with strcoll(const char s1, const char s2)
I am wondering if there is an equivalence in MySQL.
thanks in advance
