thx for your responses.

now i see the collate is affecting my order, but i can't change the collate and all the queries that order in some char field in the...