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