201125-Mysql 字符集不一致问题

做一个简单的如下的连表查询,居然直接提示错误,居然是字符集不一致的问题,本文记录一下mysql的字符集类型,以及下面这个问题的解决方案

1
2
3
select a.id, b.id from tt as a, t2 as b where a.xx = b.xx

-- Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×

a class="level is-marginless" href="/hexblog/categories/前端/ReactJS/"> ReactJS 2
  • Vue 1
  • 实战 1
  • 工具 10
  • 开源 49
  • 火花 4
  • 随笔 9
  • Your browser is out-of-date!

    Update your browser to view this website correctly. Update my browser now

    ×