List:General Discussion« Previous MessageNext Message »
From:Wes James Date:May 30 2012 9:49pm
Subject:Re: sort order
View as plain text  
I'll double check and get back.

Thanks,

-wes

On Wed, May 30, 2012 at 3:43 PM, Carlos Proal <carlos.proal@stripped>wrote:

>
> 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