MySQL迁移到MogDB后查询数据大小写敏感问题

适用范围

MySQL适配MogDB

问题概述

MySQL中文本默认不区分大小写，而MogDB中默认区分大小写。迁移后可能因大小写敏感，原语句查询不到数据。

问题示例

MySQL

mysql> select * from scott.dept where dname = 'sales';
+--------+-------+---------+
| DEPTNO | DNAME | LOC     |
+--------+-------+---------+
|     30 | SALES | CHICAGO |
+--------+-------+---------+
1 row in set (0.00 sec)

MogDB

omm@mysql=# select * from scott.dept where dname = 'sales';
 DEPTNO | dname | loc 
--------+-------+-----
(0 rows)

omm@mysql=# select * from scott.dept;
 DEPTNO |   dname    |   loc    
--------+------------+----------
     10 | ACCOUNTING | NEW YORK
     20 | RESEARCH   | DALLAS
     30 | SALES      | CHICAGO
     40 | OPERATIONS | BOSTON
(4 rows)

omm@mysql=