I've just a simple query to fetch a students records by his name, written in Bengali.
$student_rcrd = $wpdb->get_results("SELECT * FROM student WHERE name='আবুল কালাম আজাদ'");
Although my database have a record for 'আবুল কালাম আজাদ', the query returns zero row! But instead of this query, it works absolutely fine-
$student_rcrd = $wpdb->get_results("SELECT * FROM student WHERE name='Abul Kalam Azad'");
- The name field in the database is 'utf8_unicode_ci'
php
file itself is saved as unicodeUTF8
(without BOM) from your editor.add_filter( 'pre_get_table_charset', '__return_false' );
before the query and see if it works. If it does, then it's a collation issue (don't actually use it on production, this is just for test).