Copyright 1997-2022 the PHP Documentation Group.
mysqli::set_charset
mysqli_set_charset
Sets the default client character set
Description
Object oriented style
publicboolmysqli::set_charset(stringcharset);
Procedural style
boolmysqli_set_charset(mysqlimysql,
stringcharset);
Sets the default character set to be used when sending data from and to the database server.
Parameters
-
link
-
Procedural style only: A link identifier returned by
mysqli_connect
ormysqli_init
-
charset
-
The charset to be set as default.
Return Values
Returnstrue
on success orfalse
on failure.
Notes
使用这个函数在Windows平台上你娘家姓的d MySQL client library version 4.1.11 or above (for MySQL 5.0 you need 5.0.6 or above).
This is the preferred way to change the charset. Usingmysqli_query
to set it (such asSET NAMES utf8
) is not recommended. See theMySQL character set conceptssection for more information.
Examples
Example 3.63mysqli::set_charset
example
Object oriented style
character_set_name()); /* change character set to utf8mb4 */ if (!$mysqli->set_charset("utf8mb4")) { printf("Error loading character set utf8mb4: %s\n", $mysqli->error); exit(); } else { printf("Current character set: %s\n", $mysqli->character_set_name()); } $mysqli->close(); ?>
Procedural style
The above examples will output something similar to:
Initial character set: latin1 Current character set: utf8mb4
See Also
mysqli_character_set_name |
mysqli_real_escape_string |
MySQL character set concepts |
List of character sets that MySQL supports |