Documentation Home
Connectors and APIs Manual
Download this Manual
PDF (US Ltr) - 5.3Mb
PDF (A4) - 5.3Mb

Connectors and APIs Manual  /  ...  /  mysql_set_charset mysql_set_charset

Copyright 1997-2022 the PHP Documentation Group.

  • mysql_set_charset

    Sets the client character set


This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide. Alternatives to this function include:

PDO: Add charset to the connection string, such as charset=utf8
bool mysql_set_charset(string charset,
                       resource link_identifier= =NULL);

Sets the default character set for the current connection.



A valid character set name.


The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect is assumed. If no such link is found, it will try to create one as if mysql_connect had been called with no arguments. If no connection is found or established, an E_WARNING level error is generated.

Return Values

Returns true on success or false on failure.


This function requires MySQL 5.0.7 or later.


This is the preferred way to change the charset. Using mysql_query to set it (such as SET NAMES utf8) is not recommended. See the MySQL character set concepts section for more information.

See Also

Setting character sets in MySQL
List of character sets that MySQL supports