PHP mysqli: character_set_name() function
mysqli_character_set_name() function / mysqli::character_set_name
The mysqli_character_set_name() function / mysqli::character_set_name returns the default character set for the database connection.
Syntax:
Object oriented style
string mysqli::character_set_name ( void )
Procedural style
string mysqli_character_set_name ( mysqli $link )
Usage: Procedural style
mysqli_character_set_name(connection);
Parameter:
Name | Description | Required/Optional |
---|---|---|
connection | Specifies the MySQL connection to use. | Required |
Return value:
Returns TRUE on success or FALSE on failure.
Version: PHP 5, PHP 7
Example of object oriented style:
<?php
/* Open a connection */
$mysqli = new mysqli("localhost", "user1", "datasoft123", "hr");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* Print current character set */
$charset = $mysqli->character_set_name();
printf ("Current character set is %s\n", $charset);
$mysqli->close();
?>
Output:
Current character set is latin1
Example of procedural style:
<?php
/* Open a connection */
$link = mysqli_connect("localhost", "user1", "datasoft", "hr");
/* check connection */
if (!$link) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* Print current character set */
$charset = mysqli_character_set_name($link);
printf ("Current character set is %s\n",$charset);
/* close connection */
mysqli_close($link);
?>
Output:
Connect failed: Access denied for user 'user1'@'localhost' (using password: YES)
See also
Previous: change_user
Next: client_info
PHP: Tips of the Day
Returns a new array with $n elements removed from the left
Example:
<?php function tips_drop($items, $n = 1) { return array_slice($items, $n); } print_r(tips_drop([1, 2, 3])); print_r(tips_drop([1, 2, 3], 2)); ?>
Output:
Array ( [0] => 2 [1] => 3 ) Array ( [0] => 3 )
- Weekly Trends
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
- JavaScript functions Exercises
- Python Tutorial
- Python Array Exercises
- SQL Cross Join
- C# Sharp Array Exercises