Skip to content

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

Open
@SimleZhaoXu

Description

@SimleZhaoXu

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions