Question

How to get the default character set for the database connection 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 (mysqli_connect_errno()) 
    die("Connection Error: " . mysqli_connect_error() . "<br />");

$charset = $con->character_set_name();
echo $charset;

$con->close();


/*
run: 

latin1 

*/

 

70+ SQL courses for beginners and professionals