APIJSON
APIJSON copied to clipboard
[Bug] MySQL版本8.0以上,正则~,会出现问题!大佬们怎么解决的
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?/其它补充说明?
No response
DemoSQLConfig.getDBVersion 要配置成 8.0 的
https://github.com/Tencent/APIJSON/issues/563#issuecomment-1546540762