Confusion. Saving UTF-8 in MySql

[afridy]

Hi folks,

i am saving Arabic Names to mysql through a HTML (Bootstrap) / Php From. After saving, when i viewed the data through phpmyadmin / heidisql all i see is strange charactos, not arabic.

Has this saved correctly? but when i issued a query in phpmyadmin for the name i entered, then no result is shown.

Field Data format

[afridy]

Thanks folks, this has been solved by adding the follwoing code to the php script which saves these data

$query = $db->query("SET NAMES 'utf8'");
$query->execute();