List:General Discussion« Previous MessageNext Message »
From:Wes James Date:May 30 2012 9:59pm
Subject:Re: sort order
View as plain text  
In phpMyAdmin it says the database collation is utf8_unicode_ci and each of
the columns is utf8_unicode_ci except the ID primary key column.

If you create a simple table with ID and TITLE and put the data below (each
row in a record) and run 'select * from table order by title' what do you
get?

CREATE TABLE IF NOT EXISTS `testtab` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

The above is a sample export of what I have for the table definition.

-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