Mysql 插入中文错误:Incorrect string value: \\xE7\\xA8\\x8B\\xE5\\xBA\\x8F… for column course at row 1_ch717828的专栏-CSDN博客_1366 – incorrect string value: \\xe5\\xa5\\xb3 for column sex at row 1

Source: Mysql 插入中文错误:Incorrect string value: \\xE7\\xA8\\x8B\\xE5\\xBA\\x8F… for column course at row 1_ch717828的专栏-CSDN博客_1366 – incorrect string value: \\xe5\\xa5\\xb3 for column sex at row 1

 

重點是:  雖然server換成了utf-8 但是欄位資料之前是latin,還是要手動將每張表轉成utf8

 

 alter table score change score score varchar(50) character utf8;