Question

How to set MySQL character set using MySQLi in PHP

Answer 1

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';
 
$con = new mysqli('localhost', $db_user, $db_password, $db_name);
 
if ($con->connect_error) 
    die('Connection Error: ' . $con->server_info);
 
echo "Character set: " . $con->character_set_name() . "<br />";

// change character set to utf8 
if (!$con->set_charset("utf8")) 
{
    echo "Error loading character set utf8: " . $con->error;
    exit();
} 
else 
    echo "Character set: " . $con->character_set_name();


$con->close();

/*
run: 

Character set: latin1
Character set: utf8 

*/

 

70+ SQL courses for beginners and professionals