Where does the PHP/MySQL connection take its default charset?

Question

I use mysql_connect to a database solely defined in UTF-8. Everywhere I can look in the configuration, I see UTF-8 Unicode (utf8) or utf8_general_ci.

However, when I open the PHP connection, then use echo mysql_client_encoding();, I get latin1 as an output, which is pretty unexpected. Is it taken from some kind of PHP/Apache configuration?

genesis · Accepted Answer · 2011-07-23T17:36:33.680

3

In /etc/mysql/my.cnf add this line under [client]

default-character-set=utf8

edited Jul 23 '11 at 17:36

answered Jul 11 '11 at 16:39

genesis

343
4
15

score 0 · Answer 2 · answered Jul 11 '11 at 16:43

0

You have to set the encoding for your PHP MySQL connection as it does not read it from your table/database definition. Do it like this:

mysql_set_charset('utf8',$link);
// or in OOP style:
$mysqli->set_charset('utf8');

answered Jul 11 '11 at 16:43

2ndkauboy

73
3
14

Where does the PHP/MySQL connection take its default charset?

2 Answers2