List:General Discussion« Previous MessageNext Message »
From:Wes James Date:May 30 2012 9:02pm
Subject:sort order
View as plain text  
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