Mysql page garbled

Mysql page garbled problem, you can change the encoding format of the mysql database to the same, UTF8 or gbk1. database encoding www.2cto.com 2. table encoding 3. my. ini modifies the mysql character encoding to UTF8 Mysql database, which is an open source database and is widely used. The following describes how to modify the character encoding of the mysql database. Step 1: view the current character encoding method mysql> show variables like 'character % '; + metrics + | Variable_name | Value | + metrics + | character_set_client | latin1 | character_set_connection | latin1 | character_set_database | latin1 | metrics | binary | latency | latin1 | | character_set_server | latin1 | Character_set_system | utf8 | character_sets_dir |/usr/share/mysql/charsets/| + ------------------------ + rows + 8 rows in set (0.00 sec) characters are encoded as latin1, when you insert a character type (char) record to the data table, data of the character type may not be displayed normally when this record is displayed. Therefore, we modify the mysql character encoding to UTF8. The operation is as follows: www.2cto.com Step 2: modify my. the cnf configuration file is modified as follows: [client] # password = your_password port = 3306 socket =/var/lib/mysql. sock default-character-set = utf8 # set the default encoding to UTF8