Gossamer Forum: General: Databases and SQL: Sort problem for international category names in MySQL using ORDER BY

Apr 18, 2002, 10:51 AM

webmaster33

Veteran (2312 posts)

Apr 18, 2002, 10:51 AM

Post #1 of 6

Shortcut

Sort problem for international category names in MySQL using ORDER BY

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...

Apr 25, 2002, 4:27 PM

webmaster33

Veteran (2312 posts)

Apr 25, 2002, 4:27 PM

Post #2 of 6

Shortcut

Re: [webmaster33] Sort problem for international category names in MySQL using ORDER BY In reply to

Alex, please check this thread.
It's about important LSQL & MySQL international character sorting problem.

Best regards,
Webmaster33

Apr 25, 2002, 5:01 PM

Alex

Administrator (9387 posts)

Apr 25, 2002, 5:01 PM

Post #3 of 6

Shortcut

Re: [webmaster33] Sort problem for international category names in MySQL using ORDER BY In reply to

Hi,

Perl based sorting is not practical for large amount of resutls, and would dramatically affect the performance of the system. It also prevents complex sorting that you can do quite easily (i.e. Priority DESC, Title ASC). I really think the best solution here is to startup MySQL with the proper charset encoding.

Cheers,

Alex
--
Gossamer Threads Inc.

Apr 25, 2002, 5:38 PM

webmaster33

Veteran (2312 posts)

Apr 25, 2002, 5:38 PM

Post #4 of 6

Shortcut

Re: [Alex] Sort problem for international category names in MySQL using ORDER BY In reply to

Hi Alex,

I understand your point, about performance.
But this still not solves the problem of multiple languages.

Quote:

I really think the best solution here is to startup MySQL with the proper charset encoding.

Nope. If you want to use multiple template sets for multiple languages, and you need sortings for several language locale, then it is not possible, while we use MySQL sorting. Frown