I'll double check and get back. Thanks,
-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 >> 