Latest web development tutorials
 

PHP mysqli_set_charset() Function

< PHP MySQLi Reference

Example

Set the default client character set:

<?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);
?>

Definition and Usage

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

Note: For this function to work on a Windows platform, you need MySQL client library 4.1.11 or above (for MySQL 5.0 you need 5.0.6 or above).


Syntax

mysqli_set_charset(connection,charset);

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

Technical Details

Return Value: TRUE on success. FALSE on failure
PHP Version: 5.0.5+

< PHP MySQLi Reference