如何在wordpress中的wp-db文件中设置mysql_query（'set Names utf8'）

Question

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

Answer 1

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.