List:General Discussion« Previous MessageNext Message »
From:Carlos Proal Date:May 30 2012 9:43pm
Subject:Re: sort order
View as plain text  
Hi Wes, have you double checked you character set and collation ??

http://dev.mysql.com/doc/refman//5.5/en/charset-charsets.html

The collation is which determines the sorting order.

Carlos Proal


On Wed, May 30, 2012 at 4:02 PM, Wes James <comptekki@stripped> wrote:

> I have mysql 5.1.62-0ubuntu0.11.10.1 installed, but the sort order for
> utf8-unicode doesn't seem to be right.  It is sorting some text like this
> (order by title):
>
> !
> ! *`-=[];',./~@#$%^&()_+{}|:"<>?\
> !"
> ![
> !@
> !a
> !A
> !t
> !test
> 'Coal age'
> [
> \--\
> 100 years
>
> when it should be (shouldn't it?):
>
> !
> ! *`-=[];',./~@#$%^&()_+{}|:"<>?\
> !"
> !@
> !A
> ![
> !a
> !t
> !test
> 'Coal age'
> 100 years
> [
> \--\
>
>
> ------------------------------
>
> Why is it doing this?
>
> Thanks,
>
> -wes
>

Thread
sort orderWes James30 May
  • Re: sort orderCarlos Proal30 May
    • Re: sort orderWes James30 May
    • Re: sort orderWes James30 May
  • RE: sort orderRick James30 May