mysqli::set_charset

定義和用法

set_charset() / mysqli_set_charset()函數指定在與數據庫服務器發送和接收數據時使用的默認字符集。

注意：要在Windows 平台上使用此函數，您需要MySQL 客戶端庫4.1.11 或更高版本（對於MySQL 5.0，您需要5.0.6 或更高版本）。

實例

例子1 - 面向對像風格

更改默認客戶端字符集：

 <?php
$mysqli = new mysqli ( "localhost" , "my_user" , "my_password" , "my_db" ) ;

if ( $mysqli -> connect_errno ) {
  echo "Failed to connect to MySQL: " . $mysqli -> connect_error ;
  exit ( ) ;
}

echo "Initial character set is: " . $mysqli -> character_set_name ( ) ;

// 將字符集更改為utf8
$mysqli -> set_charset ( "utf8" ) ;

echo "Current character set is: " . $mysqli -> character_set_name ( ) ;

$mysqli -> close ( ) ;
?>

例子2 - 過程式風格

更改默認客戶端字符集：

 <?php
$con = mysqli_connect ( "localhost" , "my_user" , "my_password" , "my_db" ) ;

// 檢查連接
if ( mysqli_connect_errno ( ) ) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error ( ) ;
  exit ;
}

echo "Initial character set is: " . mysqli_character_set_name ( $con ) ;

// 將字符集更改為utf8
mysqli_set_charset ( $con , "utf8" ) ;

echo "Current character set is: " . mysqli_character_set_name ( $con ) ;

mysqli_close ( $con ) ;
?>