当前位置: 代码迷 >> 综合 >> Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci
  详细解决方案

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci

热度:11   发布时间:2024-03-06 14:18:30.0

报错太长,题目容不下:

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'

SET collation_connection = 'utf8_general_ci';

 

ALTER DATABASE your_database_name CHARACTER SET utf8 COLLATE utf8_general_ci;ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

 

 

 

  相关解决方案