php - 这是使用 MySQL 和 UTF8 使用 UTF8 编码获取数据的正确方法吗

Question

<?php
require_once('config.php');
require_once 'convertArraytoJson.php';

$connection=mysql_connect ( "localhost", $databaseuser, $databasepassword );
//mysql_set_charset('utf8'); //Is this better than the last line? 
mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'"); //Which one is better?
@mysql_select_db ($databasename) or die ( "Unable to select database" );
$query="SELECT `Building` FROM `tablebuilding` WHERE ID=51";
$data = mysql_query($query);
while (true){
    $info = mysql_fetch_array ( $data, MYSQL_ASSOC );
    if ($info == false) {
        break;
    }
    $output = $info['Building'];
}
//$output is FX Lifestyle X’nter
$v= htmlspecialchars ($output); //Should I use this?


$result = json_encode($output);
//$result is FX Lifestyle X\u2019nter 
echo ($result);

?>

只是想验证这是正确的方法吗？

mysql_set_charset('utf8') 和 mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8' 有什么区别', character_set_server = 'utf8'");

哪个更好。

Answer 1

JSON 只是数据交换的开放标准。如果您发送 json 编码的字符串，如果客户端支持 JSON，则客户端会将您的字符串转换为正确的字符集。尝试使用客户端 JavaScript 解释器并检查您的客户端是否支持 JSON:

 echo "<script>document.write('$result');</script>";