(PHP 5, PHP 7, PHP 8)
mysqli::character_set_name -- mysqli_character_set_name — Returns the current character set of the database connection
Object-oriented style
public mysqli::character_set_name(): string
Procedural style
mysqli_character_set_name(mysqli $mysql): string
Returns the current character set of the database connection.
mysql
Procedural style only: A mysqli object returned by mysqli_connect() or mysqli_init()
The current character set of the connection
Example #1 mysqli::character_set_name() example
Object-oriented style
<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* Set the default character set */
$mysqli->set_charset('utf8mb4');
/* Print current character set */
$charset = $mysqli->character_set_name();
printf("Current character set is %s\n", $charset); Procedural style
<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = mysqli_connect("localhost", "my_user", "my_password", "world");
/* Set the default character set */
mysqli_set_charset($mysqli, 'utf8mb4');
/* Print current character set */
$charset = mysqli_character_set_name($mysqli);
printf("Current character set is %s\n", $charset); The above examples will output:
Current character set is utf8mb4
© 1997–2025 The PHP Documentation Group
Licensed under the Creative Commons Attribution License v3.0 or later.
https://www.php.net/manual/en/mysqli.character-set-name.php