posts - 126,comments - 1,trackbacks - 0

1.asciistr:匹配字段中是否有中文字段:

select asciistr('中文,zhongwen') from dual;

2.to_multi_byte、to_single_byte:匹配字段中的全角半角字符:

select to_multi_byte('test') from dual;
select to_single_byte('test') from dual;

 

posted on 2019-01-03 11:13 Tomatoes 阅读(...) 评论(...) 编辑 收藏