Easy Tutorial
❮ Func Filter Var Func Array Udiff Uassoc ❯

PHP mysqli_set_charset() Function

PHP MySQLi Reference Manual

Set the default client character set:

<?php 
// Assume database username: root, password: 123456, database: tutorialpro 
$con = mysqli_connect("localhost", "root", "123456", "tutorialpro"); 
if (mysqli_connect_errno($con)) 
{ 
    echo "Failed to connect to MySQL: " . mysqli_connect_error(); 
} 

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

mysqli_close($con);
?>

>

This operation is very useful for handling Chinese characters, as many cases of garbled database queries are due to character set issues.


Definition and Usage

The mysqli_set_charset() function specifies the default character set to be used when sending data to and from the database server.

Note: On Windows platforms, you need MySQL client library 4.1.11 or above (MySQL 5.0 requires 5.0.6 or above) to use this function.


Syntax

Parameter Description
connection Required. Specifies the MySQL connection to use.
charset Required. Specifies the default character set.

Technical Details

Return Value: Returns TRUE on success, FALSE on failure.
PHP Version: 5.0.5+
--- ---
❮ Func Filter Var Func Array Udiff Uassoc ❯