Oracle字符函数应用检测汉字的方法

create table test(a varchar2(10));insert into test values('鸟');insert into test values('深刻');insert into test values('aaa');insert into test values('bbb');insert into test values('b鸟bb');SELECT * FROM TEST;

select a, asciistr(a) from test where asciistr(a) like '%/%'; -- 结果是有汉字的select a ,asciistr(a) from test where asciistr(a) not like '%/%'; -- 结果是不包含汉字的

select a, length(a) , lengthb(a) from TEST where length(a) != lengthb(a) ; --结果是有汉字的