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 >