SELECT * FROM v$nls_parameters WHERE PARAMETER='NLS_CHARACTERSET';
SELECT LENGTHB('啊') FROM DUAL;
LENGTH函数求得是占用字符数,LENGTHB或者VSIZE函数求得是占用字节数
SELECT * FROM v$nls_parameters WHERE PARAMETER='NLS_CHARACTERSET';
SELECT LENGTHB('啊') FROM DUAL;
LENGTH函数求得是占用字符数,LENGTHB或者VSIZE函数求得是占用字节数
转载于:https://my.oschina.net/lovesesun/blog/476533