[Bug] MySQL版本8.0以上，正则~，会出现问题！大佬们怎么解决的

Tencent / APIJSON

🏆 实时零代码、全功能、强安全 ORM 库 🚀 后端接口和文档零代码，前端(客户端) 定制返回 JSON 的数据和结构 🏆 Real-Time coding-free, powerful and secure ORM 🚀 providing APIs and Docs without coding by Backend, and the returned JSON of API can be customized by Frontend(Client) users

Other

17.27k stars 2.16k forks source link

APIJSON Version/APIJSON 版本号

5.4.0

Database Type & Version/数据库类型及版本号

8.0.1

Environment/环境信息

- JDK/基础库:
- OS/系统:
"msg": "Character set 'utf8mb4_bin' cannot be used in conjunction with 'binary' in call to regexp_like.",

APIAuto Screenshots/APIAuto 请求与结果完整截屏

"msg": "Character set 'utf8mb4_bin' cannot be used in conjunction with 'binary' in call to regexp_like.",

Current Behavior/问题描述

"key~": "2002150001|2002150002"

以上正则~会有问题，在MySQL是5.0版本是没问题，在8.0以上版本，这种的都是怎么解决的？

Expected Behavior/期望结果

No response

Any additional comments?/其它补充说明？