判断字段中是否包含中文的方法(转)

判断字段中是否包含中文的方法(转)

SQL> create table test(a varchar2(10));

Table created.

SQL> insert into test values('鸟');

1 row created.

SQL> commit;

Commit complete.

SQL> insert into test values('深刻');

1 row created.

SQL> commit;

Commit complete.

SQL> insert into test values('aaa');

1 row created.

SQL> insert into test values('bbb');

1 row created.

SQL> commit;

Commit complete.

SQL> select a from test;

A
----------
鸟
深刻
aaa
bbb

SQL> select a from test where asciistr(a) like '%\%';

A
----------
鸟
深刻

SQL> select a from test where asciistr(a) not like '%\%';

A
----------
aaa
bbb

select legth(column_name) , lengthb(column_name) from table_name
where length(column_name) != lengthb(column_name) ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/644902/viewspace-159245/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/644902/viewspace-159245/