php8.5
Home/ Manual/ mysqli / mysqli/ mysqli::character_set_name

mysqli::character_set_name

PHP function Edit on GitHub ✎

(PHP 5, PHP 7, PHP 8)

Returns the current character set of the database connection

Description

Oop

mysqli::character_set_name(): string

Procedural

mysqli_character_set_name(mysqli $mysql): string

Returns the current character set of the database connection.

Parameters

Return Values

The current character set of the connection

Examples

mysqli::character_set_name example

Oop

php
<?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

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

Outputs

output
Current character set is utf8mb4

See Also

Source: reference/mysqli/mysqli/character-set-name.xml · from the official PHP manual (php/doc-en)