MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: utf8 in database but order does not sort correct
Posted by: chapacan
Date: October 16, 2006 01:34AM

I'm having the same problems with a database in utf8 charset, and utf8_spanish2_ci collation. I have tried utf8_spanish_ci too.

Mysql doesn't order result sets correctly, the characters 'ñ', 'Ñ','á', 'Á',... 'Ú', are placed before the characters 'a', 'b', 'c'... They should be in another positions:

'á', 'a', .... 'n', 'ñ', 'Ñ', 'o'.

¿Someone culd help me?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
utf8 in database but order does not sort correct
12175
Markus Rietzler
April 13, 2006 03:05AM
Re: utf8 in database but order does not sort correct
5369
Markus Rietzler
April 13, 2006 07:35AM
Re: utf8 in database but order does not sort correct
4734
Markus Rietzler
April 18, 2006 03:59AM
Re: utf8 in database but order does not sort correct
4220
Alexander Barkov
April 25, 2006 02:24AM
Re: utf8 in database but order does not sort correct
7017
walter
June 13, 2006 04:41AM
Re: utf8 in database but order does not sort correct
4709
Alexander Barkov
June 20, 2006 12:03AM
Re: utf8 in database but order does not sort correct
4127
Peter Russ
August 30, 2006 04:58AM
Re: utf8 in database but order does not sort correct
4214
chapacan
October 16, 2006 01:34AM
Re: utf8 in database but order does not sort correct
4033
Peter Gulutzan
October 16, 2006 09:03AM


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.