PHP: mysql_client_encoding

mysql_client_encoding

(PHP 4 >= 4.3.0, PHP 5)

mysql_client_encoding -- Returns the name of the character set

Description

string mysql_client_encoding ( [resource link_identifier] )

Retrieves the character_set variable from MySQL.

Parameters

link_identifier: 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() was called with no arguments. If by chance no connection is found or established, an E_WARNING level warning is generated.

Return Values

Returns the default character set name for the current connection.

Examples

Example 1. mysql_client_encoding() example

<?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); $charset = mysql_client_encoding($link); echo "The current character set is: $charset\n"; ?>
The above example will output something similar to:
The current character set is: latin1

User Contributed Notes
mysql_client_encoding

info at jantichy dot cz
30-Dec-2004 04:02


Notice the difference between following two SQL statements:



SET NAMES 'charset_name'

SET CHARACTER SET charset_name



For more detail see

http://dev.mysql.com/doc/mysql/en/Charset-connection.html

black at scene-si dot org
20-Oct-2004 06:04


the above (as it seems to be vaguely indicated in the mysql manual) works only with mysql 4.1+

stian at grytoyr dot net
19-Oct-2004 08:09


If you experience weird problems, like some UTF-8 characters (the Unicode character &#x010D and a few others in my case) seemingly being changed to garbage by mysql_query, you may need to do something like this before your actual query:



<?php

mysql_query("SET NAMES 'utf8'", $conn);

?>



Took me days to figure that one out...

mysql_client_encoding

Description

Parameters

Return Values

Examples

See Also