Unable to set client connection character set: utf8mb4

Here is a stand alone script to test if the charset is being set or not will return the error if not set.

PHP Code:

<?php

// Set these for your server
define('db_user', '');        // The database users name
define('db_password', '');    // The database password
define('db_database', '');    // The database name

$conn_id = mysqli_connect('localhost', db_user, db_password, db_database);

// check connection
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

printf("Initial character set: %s\n", mysqli_character_set_name($conn_id));

// change character set to utf8mb4
if ( ! mysqli_set_charset($conn_id, "utf8mb4"))
{
    printf("Error loading character set utf8mb4: %s\n", mysqli_error($conn_id));
    exit();
}
else
{
    printf("Current character set: %s\n", mysqli_character_set_name($conn_id));
}

mysqli_close($conn_id);

?>

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )