【 使用环境 】生产环境
【 OB or 其他组件 】 OBServer
【 使用版本 】oceanbase-ce-3.1.4-10000092022071511
【问题描述】
SQL 语句
select * from `test` where name like N'张%';
错误提示：
1064 - You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘‘张%’’ at line 1
该语句在MySQL中能正常执行，请问是否支持该格式查询？
【复现路径】
create table test (id int NOT NULL AUTO_INCREMENT,name varchar(20), PRIMARY KEY (`id`));
insert into test (name) values ('张三'),('李四'),('王五'),('赵六');
select * from `test` where name like N'张%';
【问题现象及影响】
1064 - You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘‘张%’’ at line 1
【附件】无