mysql show?variables?like?'character%';
會出現下面的數據
|?character_set_client?????|?latin1?????????????????????| |?character_set_connection?|?latin1?????????????????????| |?character_set_database???|?utf8???????????????????????| |?character_set_Filesystem?|?binary?????????????????????| |?character_set_results????|?latin1?????????????????????| |?character_set_server?????|?latin1?????????????????????| |?character_set_system?????|?utf8???????????????????????| |?character_sets_dir???????|?/usr/share/mysql/charsets/?|
從以上信息可知數據庫的編碼為latin1；
其中，character_set_client為客戶端編碼方式；character_set_connection為建立連接使用的編碼；character_set_database數據庫的編碼；
character_set_results結果集的編碼；
character_set_server數據庫服務器的編碼；
直接修改sqlyog的編碼格式就好了
SET?NAMES?'latin1'??;
CREATE?DATABASE?`ssp`?DEFAULT?CHARACTER?SET?utf8?COLLATE?utf8_general_ci;
【相關推薦】
? 版權聲明
文章版權歸作者所有，未經允許請勿轉載。
THE END
