Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation {callout color="#1dc0f7"}最近一位朋友说打不开我的留言板页面，一直报错500【Database QueryError】，于是我查找了错误日志，找到了如下错误信息：{/callout}2022/01/01 15:01:34 [error] 27751#0: *92883 FastCGI sent in stderr: "PHP message: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='" while reading response header from upstream, client: ***.9.208.203, server: www.xtboke.com, request: "GET /message.html HTTP/2.0", upstream: "fastcgi://unix:/tmp/php-cgi-72.sock:", host: "www.xtboke.com"{callout color="#f0ad4e"}于是查找资料，貌似是编码不一致的问题，也试过了网上的一些方法，基本都不管用；下面说一下我通过资料总结的方法：仅供参考，至少我的问题是解决了。{/callout}第一步：如下第二步：找到数据库配置文件database.php，做如下修改：'charset' => 'utf8mb4'