Trace:

Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+====== MySQL Character Sets ======
+  * [[MySQL]]
+MySQL, by default, uses LATIN1 encoding.  You can verify this by opening up a ''mysql'' shell and
+running this statement:
+<code>
+SHOW VARIABLES WHERE variable_name = 'character_set_client';
+</code>
+=== MySQL and PHP ===
+See what encoding PHP is using to connect as:
+<code>
+$link = mysql_connect('localhost', 'user', 'pass');
+$charset = mysql_client_encoding($link);
+</code>
+Likewise, you can override the setting and change it.  The code must be directly after creating the MySQL connection:
+<code>
+$link = mysql_connect('localhost', 'user', 'pass');
+$bool = mysql_set_charset('utf8', $link);
+$charset = mysql_client_encoding($link);
+</code>
+Using ''mysqli'' driver instead of ''mysql'':
+<code>
+$link = mysqli_connect('localhost', 'user', 'pass', 'world');
+mysqli_set_charset('utf8', $link);
+$charset = mysqli_character_set_name($link);
+</code>
+=== Global Variables ===
+You can change the database to use UTF8 by changing the runtime variables:
+<code>
+SET @@character_set_client = 'utf8';
+SET @@character_set_connection = 'utf8';
+SET @@character_set_database = 'utf8';
+SET @@character_set_results = 'utf8';
+SET @@character_set_server = 'utf8';
+</code>
+=== Database Configuration ===
+MySQL needs to be configured to use UTF8, or it will still use LATIN1 by default:
+<code>
+[mysqld_safe]
+character-set-server=utf8
+[mysqld]
+character-set-server=utf8
+[client]
+default-character-set=utf8
+[mysqldump]
+default-character-set=utf8
+[mysql]
+default-character-set=utf8
+[mysqladmin]
+default-character-set=utf8
+[mysqlcheck]
+default-character-set=utf8
+[mysqlimport]
+default-character-set=utf8
+[mysqlshow]
+default-character-set=utf8
+</code>

Differences

Search

Toolbox