Anybody knows how can mysql ORDER BY international strings?
I know this is not just LSQL problem, but I can not solve it. Maybe somebody knows it.
I would need to do sortings for different international languages.
So locale definition should be changed within MySQL.
(changing locale for the system is not solution, because I need
to change more times for different languages)
How it is possible?
Currently the ORDER BY is sorting categories by English locale, putting the non-English starting category names to the last position.
I would like to keep ordering with MySQL ORDER BY, and not to do additional sortings in Perl.
By the way: setting correct perl locales did not help (of course).
Please help! Any ideas are welcome!
Best regards,
Webmaster33
Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
I know this is not just LSQL problem, but I can not solve it. Maybe somebody knows it.
I would need to do sortings for different international languages.
So locale definition should be changed within MySQL.
(changing locale for the system is not solution, because I need
to change more times for different languages)
How it is possible?
Currently the ORDER BY is sorting categories by English locale, putting the non-English starting category names to the last position.
I would like to keep ordering with MySQL ORDER BY, and not to do additional sortings in Perl.
By the way: setting correct perl locales did not help (of course).
Please help! Any ideas are welcome!
Best regards,
Webmaster33
Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
MySQL problem using ORDER BY for international category names