| davidklonski 2004-04-15, 7:32 pm |
| 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
----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums
|