phpMyAdmin不会将Unicode（utf-8）字符正确显示到数据库中，但在Web中正确显示[复制]

Question

This question already has an answer here:

• How to display UTF-8 characters in phpMyAdmin? 18 answers

sorry if my question is duplicate , after googling i found a answer for my question that says:

 1-go to libraries folder
 2-finding file database_interface.lib.php
 3-comment below code:


  if (! empty($GLOBALS['collation_connection'])) {
  PMA_DBI_query("SET CHARACTER SET 'utf8';", $link, PMA_DBI_QUERY_STORE);
   $mysql_charset = explode('_', $GLOBALS['collation_connection']);
   PMA_DBI_query("SET collation_connection = '" .      PMA_sqlAddslashes($GLOBALS['collation_connection']) . "';", $link,

  PMA_DBI_QUERY_STORE);
   } else {
   PMA_DBI_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci';", $link,      PMA_DBI_QUERY_STORE);
 }

now my problem is i do not have (database_interface.lib.php) in libraries folder

version of my xampp is 3.2.2

</div>

Answer 1

I added below code before any insert and select statements, and now it works.

$conn->set_charset('utf8');