Download this Manual
PDF (US Ltr) - 2.8Mb
PDF (A4) - 2.8Mb
EPUB - 457.1Kb
HTML Download (TGZ) - 396.3Kb
HTML Download (Zip) - 410.1Kb

MySQL PHP API  /  ...  /  mysql_set_charset

5.5.44 mysql_set_charset

Copyright 1997-2014 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 and related FAQ for more information. 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

User Comments
Sign Up Login You must be logged in to post a comment.