Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Re: [Paul] MySQL problem using ORDER BY for international category names

Apr 26, 2002, 7:08 PM
webmaster33
Veteran (2312 posts)
Apr 26, 2002, 7:08 PM
Views: 2022
Shortcut
Quote Reply
Re: [Paul] MySQL problem using ORDER BY for international category names In reply to
Eh, Paul,

I did suggestions about a bug, which causes incorrect sorting in Links SQL.
The keywords are suggestions and bug. See?

Well, I have a software, which is not able to do sorting as it should. Does not matter if the reason is a bug in MySQL or anything else. Result is not correct for my national language (all accent characters are sorted to the end of lists...). Therefore I try to find a solution how to solve this problem...

Quote:
perl based sorting over mysql....eek.
If MySQL is not working correctly (only in respect of international string collate support), then what else can you do? Do sorting in just Perl. Or do MySQL sort + resort with Perl (resorting an already sorted list is much faster).

But if you have a working solution, let me know. Wink

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...
Subject Author Views Date
Thread MySQL problem using ORDER BY for international category names webmaster33 2141 Apr 16, 2002, 5:08 PM
Thread Re: [webmaster33] MySQL problem using ORDER BY for international category names 		webmaster33 2056 Apr 25, 2002, 4:23 PM
Thread Re: [webmaster33] MySQL problem using ORDER BY for international category names 		Paul 2028 Apr 26, 2002, 2:34 AM
Post Re: [Paul] MySQL problem using ORDER BY for international category names 		webmaster33 2022 Apr 26, 2002, 7:08 PM