Eternal Night

Tagged: 官方 Bug

查看 MySQL 官方文档，参考：https://bugs.mysql.com/bug.php?id=81990 。在 MySQL 版本：5.6.31/5.7.13 中，排序规则，其值为：utf8mb4_unicode_ci 时，皆需要针对 \ 的搜索，再添加 1 根，才能够搜索出结果。此 Bug 在 MySQL 版本：8.0.18 得以修复 0

PHP / SQL / Yii / MySQL 5.6 / MySQL 5.7 / Web Application Development / MySQL 8.0 / Database / Navicat / Programming Language / PHP 7.4 / Web Framework / Yii 2 / MySQL / Navicat for MySQL / Database Management Tools / Navicat for MySQL 12

In Yii 2.0, use the like operator to find \ , the result is empty analysis, because the official bug of the mysql version

浏览量： 1 1. Request parameter: filter[and][0][or][0][title][like]=\, the generated sql is as follows, the search result is empty. as shown in Figure 1 2. Check the value of the field title in the table plan,...