判断字段中是否含有中文

最新推荐文章于 2020-12-19 11:34:47 发布

cuichuang1982

最新推荐文章于 2020-12-19 11:34:47 发布

阅读量92

点赞数

文章标签：数据库

SELECT *
FROM dept
WHERE ASCIISTR (dname) LIKE '%\%' AND INSTR (dname, '\') <= 0;

Oracle® Database SQL Reference
10g Release 2 (10.2)中关于ASCIISTR函数的解释：

ASCIISTR takes as its argument a string, or an expression that resolves to a string, in any character set and returns an ASCII version of the string in the database character set. Non-ASCII characters are converted to the form. \xxxx, where xxxx represents a UTF-16 code unit.

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

转载于:http://blog.itpub.net/10314474/viewspace-622021/