10bet网址
MySQL PHP API
Download this Manual
PDF (US Ltr)- 2.4Mb
PDF (A4)- 2.4Mb


MySQL PHP API/.../ mysqli::set_charset, mysqli_set_charset

3.8.47mysqli::set_charset,mysqli_set_charset

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 bymysqli_connectormysqli_init

charset

The charset to be set as default.

Return Values

Returnstrueon success orfalseon failure.

Notes

Note

使用这个函数在Windows平台上你娘家姓的d MySQL client library version 4.1.11 or above (for MySQL 5.0 you need 5.0.6 or above).

Note

This is the preferred way to change the charset. Usingmysqli_queryto set it (such asSET NAMES utf8) is not recommended. See theMySQL character set conceptssection for more information.

Examples

Example 3.63mysqli::set_charsetexample

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