I started a thread in Links SQL: Discussions, with similar subject:
"MySQL problem using ORDER BY for international category names"
I renamed because it may describe better my problem.
Please check here:
http://www.gossamer-threads.com/...orum.cgi?post=192124
Example category names:
Vision, Files, Computers, Überalles, Accessories.
Sorting category names above will result following order:
Accessories, Computers, Files, Vision, Überalles.
(Of course Überalles should be before Vision, so sorting is bad)
I checked MySQL docs, and found that there is only possible to change character set if you restart MySQL server.
Alex, don't you think, that would be better to change MySQL based ordering to Perl based ordering?
Or at least to make Perl based ordering optional?
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"
I renamed because it may describe better my problem.
Please check here:
http://www.gossamer-threads.com/...orum.cgi?post=192124
Example category names:
Vision, Files, Computers, Überalles, Accessories.
Sorting category names above will result following order:
Accessories, Computers, Files, Vision, Überalles.
(Of course Überalles should be before Vision, so sorting is bad)
I checked MySQL docs, and found that there is only possible to change character set if you restart MySQL server.
Alex, don't you think, that would be better to change MySQL based ordering to Perl based ordering?
Or at least to make Perl based ordering optional?
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...