Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : MySQL Functions : mysql_client_encoding

mysql_client_encoding

Returns the name of the character set (PHP 4 >= 4.3.0, PHP 5, PECL mysql:1.0)
string mysql_client_encoding ( [resource link_identifier] )

Example 1413. 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

Code Examples / Notes » mysql_client_encoding

gz

This one also may be necessary for happy work with utf-8, if you have no other encodings.
In server section add:
init-connect='SET NAMES utf8'
(from MySQL manual)


alamakota

There's no 'character_set' variable available in MySQL. You can check it yourself in MySQL online documentation or by running MySQL query "SHOW VARIABLES LIKE 'character_set%';".
This must be an error in PHP manual, unless I'm missing something.


zayfod

The right lines to put in /etc/my.cnf (or other MySQL options file) are:
[client]
init-command="SET NAMES utf8"
Unfortuantely the PHP mysql_connect() function does not use MySQL options files so this is not a sollution for changing the default connection character set for mysqlclient library v4.1+.
The only working sollution remains:
mysql_query("SET NAMES utf8", $conn);
(of course /ext/mysql/php_mysql.c can always be patched ;] )


black

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

php

Please note that even if you set the charset by issuing the two mentioned SQL statements (set names, set character set) mysql_client_encoding still deliveres the old result.
Default for me is latin1. After switching to UTF8 mysql_client_encoding still returns latin1. The charset switched to UTF8 successfully, though.


info

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


wio

If you set the encoding in my.cnf like
[mysqld]
init_connect='SET NAMES utf8'
note that the content of init_connect  is not executed for users that have the SUPER privilege - ie root!


stian

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...


devos

I use mysql 3.23 and none of the above worked for me. Looking at http://dev.mysql.com/tech-resources/articles/4.1/unicode.html as advised by romain at dardour dot com, I tried to include the following header in my php scripts, and all the funy characters disapeared. Hope it will help.
<?php header("Content-type: text/html; charset=latin1");?>
(my mysql character was latin1)


vrbcik

I have had problems with encoding after export of tables (from hosting - via PhpMyAdmin) and import them to other machine (my notebook - via PhpMyAdmin too). In PhpMyAdmin the encoding of all data was shown correctly, not that good with the web pages (data pulled via php).
The first point is indication, that the data was imported correctly, but php script has got other character set than MySql is sending.
The script's character set is set in header: <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-2">. MySql setting was latin1.
Then following code helped me:
<?php
mysql_query("SET CHARACTER SET 'latin2'", $conn);
?>


msieniek

I had the same problem as bartullus, I'm from Poland too. I had my base encoded in UTF-8 and my website in ISO-8859-2 aka Latin-2. Long time those fuckin' question marks appeared...
I used this function mysql_client_encoding() but it shows "latin1" which appeared to be false. My solution was to include those two lines after connection to database in my PHP script:
<?
mysql_query("SET CHARACTER SET latin2");
mysql_query("SET NAMES latin2");
?>
So, probably this function lies;)


romain

I couldn't get any luck with all the stuff mentioned below, and despite having an unicode DB, and setting all my field to utf8_general_ci...
After looking around, I found that this page: http://dev.mysql.com/tech-resources/articles/4.1/unicode.html was adding the fields with an extra info before each value:
<?
mysql_query("INSERT INTO table SET field = _utf8'value'");
?>
Mind the "_utf8" before the field value, and outside of the quotes.
This works for me wether in an Insert or an Update statement.
No need here for a <? mysql_query("SET NAMES utf8"); ?> before each query, or to change anything in the config files (that was important since I don't have access to these).


bartullus

For some reason given entry in php.ini:
default_charset = "ISO-8859-2"
nor
default_charset = "latin2"
doesn't work.
Every time you run:
$charset= mysql_client_encoding($dbh);
echo $charset;
from PHP connecting to MySQL you will get 'latin1'.
Even if all HTML/PHP pages are stored as UTF8 with header:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
and MySQL server is everywhere UTF8:
character_set_client     | utf8
character_set_connection | utf8
character_set_database   | utf8
character_set_filesystem | binary
character_set_results    | utf8
character_set_server     | utf8
character_set_system     | utf8
adding "SET NAMES latin2" and "SET CHARACTER SET latin2" into your PHP to MySQL connection you will always get question marks after doing select.
I also tried all the tips from this page and did not succeed as others stated 'it worked for me' - blah...spent 6 hours on that.
THE ONLY solution that "worked for me" and for others using latin2-iso-8859-2 (i'm from Poland) is to put single line into your SQL script with many inserts:
set name LATIN1;
After that, you can run a SQL script from QUERY BROWSER with the latin2 characters in inserts.
After only that, when you query those fields from PHP page via select you will get NO question marks and garbage.
If you use 'mysql' command line tool instead of QUERY BROWSER to run insert script you must remove "set names latin1" from the beginning of the script because of the error while processing that line. Instead of that run "set names latin1" separatelly and then run the insert script.
'mysql' works fine with "set names latin2" but only with singleline, manual inserts.
'mysql' command client works fine after switching to "set names latin2" but MySQL Query Browser do not. Query Browser v.1.2.6 beta is not great for some other reasons not worth mentioning here.
My configuration is:
Windows 2000
Apache2.2
MySQL 5.0.27
MySQL client shows 5.1.11
PHP5.2.0
and I needed to run insert script to fullfil dictionaries with initial data.


roy dot the dot geek+php

f you think "set names utf8" for each connection is too trouble, you can modify my.cnf of MySQL to solve the problem forever. In my.cnf, add the line "default-character-set=utf8" in both [mysqld] and [client] sections:
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
The MySQL will use utf8 after you restart it.


pedro pereira

All I had to do to save utf8 data with php mysql_query() was to go to the php.ini and put default_charset = "utf-8". Without this I had the same problems some of you have. Plus, all my mysql charsets vars are in 'utf8'. (Changed them with Mysql Admin Tool)
Didnt use any mysql SET **** command at all.
Mysql 4.1.20
PHP 4.4.4
Win XP
Hope this help some of you.


21-jul-2006 01:46

A very easy way to always get results in UTF-8 is to make a common function to connect to DB and in that function set character set to utf-8.
function OpenConn() {
 global $link;
 $link = mysql_connect ("localhost", "username", "password")
     or die(sendError('Could not connect to DB'));
 mysql_select_db ("dbName");
 //
 // Set character set to UTF-8
 //
 mysql_query("SET CHARACTER SET 'utf8'", $link);
}


Change Language


Follow Navioo On Twitter
mysql_affected_rows
mysql_change_user
mysql_client_encoding
mysql_close
mysql_connect
mysql_create_db
mysql_data_seek
mysql_db_name
mysql_db_query
mysql_drop_db
mysql_errno
mysql_error
mysql_escape_string
mysql_fetch_array
mysql_fetch_assoc
mysql_fetch_field
mysql_fetch_lengths
mysql_fetch_object
mysql_fetch_row
mysql_field_flags
mysql_field_len
mysql_field_name
mysql_field_seek
mysql_field_table
mysql_field_type
mysql_free_result
mysql_get_client_info
mysql_get_host_info
mysql_get_proto_info
mysql_get_server_info
mysql_info
mysql_insert_id
mysql_list_dbs
mysql_list_fields
mysql_list_processes
mysql_list_tables
mysql_num_fields
mysql_num_rows
mysql_pconnect
mysql_ping
mysql_query
mysql_real_escape_string
mysql_result
mysql_select_db
mysql_set_charset
mysql_stat
mysql_tablename
mysql_thread_id
mysql_unbuffered_query
eXTReMe Tracker