常見Error當導入MySQL Workbench

出現錯誤:error code:1366. incorrect string value

  • Condition: 如果執行
    1
    ALTER TABLE `student` default character set utf8; #utf8mb4
    格式一可能沒變,一樣是latin1
  • Solution: you can run the following code to check it again.
    輸入以下指令,設定格式latin1為 utf8
    1
    2
    ALTER TABLE `student` convert to character set utf8; #utf8mb4
    show create table `student`;
© 2022 Tiffany's Blog All Rights Reserved. 本站访客数人次 本站总访问量
Theme by hiero