MySQL 字元集

標籤：style   io   ar   sp   on   cti   bs   as   line   

查看mysql 字元集設定情況:

show variables like ‘%char%‘

+--------------------------+----------------------------------------+| Variable_name            | Value                                  |+--------------------------+----------------------------------------+| character_set_client     | gbk                                    | | character_set_connection | gbk                                    | | character_set_database   | gbk                                    | | character_set_filesystem | binary                                 | | character_set_results    | gbk                                    | | character_set_server     | gbk                                    | | character_set_system     | utf8                                   |       | /usr/local/mysql/share/mysql/charsets/ | +--------------------------+----------------------------------------+

修改變數的編碼

set @@character_set_server=‘utf8‘; 

MySQL 字元集