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