在使用concat连接字符串时出现错误：MySQL Error: Illegal mix of collations for operation 'concat'
原因：字段操作默认为UTF8的编码，应该绝对统一使用UTF-8，而创建数据库时使用了其它编码。
解决方法：在Navicat for MySQL中删除掉原来的数据库，重新新建，新建时设置字符集和排序规则为UTF-8
相关文章
- 02-19Illegal mix of collations (...) and (...) for operation 不修改表结构处理方法
- 02-19SQL查询时出现错误 “Illegal mix of collations for operation 'UNION'”
- 02-19MySQL查询时报错Illegal mix of collations
- 02-19有关mysql的utf8和utf8mb4，以及Illegal mix of collations for operation 'like'
- 02-19Illegal mix of collations for operation 'concat'
- 02-19MySQL Error: Illegal mix of collations for operation 'concat'
- 02-19mysql5.6修改字符编码，ERR：Illegal mix of collations for operation 'concat'
- 02-19Illegal mix of collations for operation 'like' while searching with Ignited-Datatables
- 02-19myslq数据库用union all查询出现 #1271 - Illegal mix of collations for operation 'UNION'
- 02-19mysql提示:Illegal mix of collations for operation ‘UNION’