Re: [webmaster33] MySQL problem using ORDER BY for international category names
I posted another thread here to describe the problem in more detail:
http://www.gossamer-threads.com/...orum.cgi?post=192455
Alex, could you check it?
I think the bug & the problem is very important, because there is not currently possible in Links SQL to change locales any time, to be able sort by international strings...
This is a bug in MySQL, and it will not be solved until version v4.2.
Therefore we should be not use MySQL ORDER BY to do sortings in Links SQL.
We should do that with Perl based sorting...
Or at least to make MySQL & Perl sorting choosable, optional.
Opinions?
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...
http://www.gossamer-threads.com/...orum.cgi?post=192455
Alex, could you check it?
I think the bug & the problem is very important, because there is not currently possible in Links SQL to change locales any time, to be able sort by international strings...
This is a bug in MySQL, and it will not be solved until version v4.2.
Therefore we should be not use MySQL ORDER BY to do sortings in Links SQL.
We should do that with Perl based sorting...
Or at least to make MySQL & Perl sorting choosable, optional.
Opinions?
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...