php - 在数据库中设置 utf8 - 我可以从 php 代码中删除 SET NAMES utf8

Question

我在mysql数据库中设置了utf8

现在显示

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+


+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_unicode_ci |
| collation_server     | utf8_unicode_ci |
+----------------------+-----------------+

我的 php 代码中有以下内容

mysql_query("SET NAMES 'utf8'");

和

$database = mysqli_connect('host','user','pass','database');
mysqli_query($database,"SET NAMES 'utf8'");

由于我在数据库中设置了 utf8，我可以删除 mysql_query("SET NAMES 'utf8'") 和 mysqli_query($database,"SET NAMES 'utf8'") 从代码中？

Answer 1

您可以使用mysqli_set_charset

<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

// Change character set to utf8
mysqli_set_charset($con,"utf8");

mysqli_close($con);
?>