mysql_client_encoding

add a note User Contributed Notes

Pedro Pereira
09-Sep-2006 10:30


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.

alamakota at mises dot pl
26-Jul-2006 10:13


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.

21-Jul-2006 08: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);

}

romain at dardour dot com
15-May-2006 11:56


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

zayfod at yahoo dot com
21-Apr-2006 07:57


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 ;] )

Wio at psitrax dot de
17-Mar-2006 01:24


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!

vrbcik
28-Nov-2005 01:26


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);

?>

info at jantichy dot cz
31-Dec-2004 06: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 07: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 09: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...

add a note

mysql_client_encoding

说明