RPAD issue with triple byte chars
Hi,
when I try to rpad a space with triple byte chars it gives the wrong output. i.e in all the cases the output should be 36.
SELECT length(RPAD('海海海海海海海' ,36,' ')) FROM DUAL -- Triple byte chars
Output:29
SELECT length(RPAD('ééééé' ,36,' ')) FROM DUAL -- Double byte chars
Output:36
SELECT LENGTH(RPAD('MAIN STREET',36,' ')) FROM DUAL -- Single byte chars
Output:36
NLS_CHARACTERSET: UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_LENGTH_SEMANTICS: BYTE
Can any body help me to sort out this.