I am using WAMP:
1. PHP 5..
2. MySQL 5..
3. Apache 2..
the collation of my database and tables and fields are 'utf8_persian_ci', and also my query is in this format in PHP:
mysql_query("SET NAMES utf8"); mysql_query("SET CHARACTER SET utf8"); $query = mysql_query("SELECT * FROM tblName SORT BY fieldName COLLATE utf8_persian_ci");
this all utf8 is for my Arabic and persian words...
I faced a problem on sorting english words, I dont know why the result on the browser is like the attachment