æå³å®å级æçDebianå®è£ ,å 天å使ç¨MySQL 5.5,æåç°mysqlæå°å°UTF-8å符çç»ç«¯intead.
æçäºä¸ä¸mysqldumpçæçSQLæ件,åç°å®å·²ç»å å«äºåå¾.ä»å¤©æå é¤äºæ°æ®åºå¹¶å¾å°äºä¸ä¸ªæ§ç/ var / lib / mysql / database_name / *çå¯æ¬,å®è¿è¡è¯å¥½,令ææ讶çæ¯,æä»ç¶å¾å°ç¸åçç»æ.
mysqldumpçæçæ件å æ¬ä»¥ä¸è¡ï¼
;
;
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
æ¥èªæ§æ°æ®åºåæ°æ°æ®åºç/var/lib/mysql/database_name/db.optæ¯ç¸åçï¼
default-character-set=latin1
default-collation=latin1_swedish_ci
æç°å¨è½åä»ä¹ï¼æå¸ææä¸ä¼å¤±å»æ´ä¸ªæ°æ®åºï¼
UPDATE
show session variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
SELECT charset(name), hex(name), name FROM table WHERE id='123';
+---------------+----------------------------------------------+----------------------------+
| charset(name) | hex(name) | name |
+---------------+----------------------------------------------+----------------------------+
| latin1 | 457361C3BA204A6F73C3A92064652053616E74616E61 | Esa?? Jos?? de Santana |
+---------------+----------------------------------------------+----------------------------+
æåä¸ä¸ªå½ä»¤ä¸çå称è¾åºåºä¸ºEsaúJosédeSantana