函数:
to_single_byte(c)转换成半角
to_multi_byte(c)转换成全角
to_multi_byte(c)转换成全角
实例:
SELECT '12345',
DUMP('12345'),
TO_SINGLE_BYTE('12345'),
DUMP(TO_SINGLE_BYTE('12345'))
SELECT '12345',
DUMP('12345'),
TO_SINGLE_BYTE('12345'),
DUMP(TO_SINGLE_BYTE('12345'))
FROM dual;
原文链接:http://blog.chinaunix.net/uid-7801695-id-68166.html