no way to compare when less than two revisions

Differences

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


mysql_character_sets [2013/10/07 20:27] (current) – created - external edit 127.0.0.1
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>
  

Navigation
QR Code
QR Code mysql_character_sets (generated for current page)