ordering (collations) in mysql4.0
Posted by: marco milli
Date: July 08, 2005 03:47AM

hi everyone

my company has a mysql4.0.20a-nt server running and ordering of german text is a bit of a problem. i yesterday posted a similar help request for mysql4.1 and the suggestions received were very helpful. unfortunately i could not apply the knowledge gained on the older mysql server. the expressions collate or collation always produce syntax errors.
my problem is the sorting of umlauts, which always appear after the letter z.

is there a way of changing the ordering of results (without upgrading the server) in order to sort 'รค' as 'ae'?

thanks in advance

marco

Options: ReplyQuote


Subject
Views
Written By
Posted
ordering (collations) in mysql4.0
2823
July 08, 2005 03:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.