I am developing a kurdish site in wordpress. I want to fetch all datas by Kurdish alphabetical order.
For example
$alpha='ش';
$results =$wpdb->get_results("SELECT * FROM ".$wpdb->prefix."books where `author_name` like '$alpha%'");
print_r($results);
this returns nothing.
But when I run this query with english alphabet it works fine. I know mysql_query('set Names utf8') is the solution for this type of problem in core php but i dont know where and how to set this mysql_query('set Names utf8'); in wp-db.php of wordpress
When your tables are UTF-8 but your connections is not, try to set the following constant:
define( 'DB_CHARSET', 'utf8' );
You can also set the column encoding:
define( 'DB_COLLATE', 'utf8_general_ci' );
WARNING: Make sure you have a backup of your database before chaning anything on the encodings.
If all of this is not the issue, the script you set the $alpha variable in might not be encoded in UTF-8.