sort order

[Wes James]

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

Re: sort order

[Wes James]

I'll double check and get back.

Thanks,

-wes

On Wed, May 30, 2012 at 3:43 PM, Carlos Proal carlos.pr...@gmail.comwrote:


 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 compte...@gmail.com 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

Re: sort order

[Wes James]

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.pr...@gmail.comwrote:


 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 compte...@gmail.com 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