utl_raw.cast_to_archar增加字符串的长度

Question

select length(initcap(utl_raw.cast_to_varchar2(nlssort('Chloé','nls_sort=binary_ai')))) 
from dual

长度-6

select length('Chloé') 
from dual

长度-5

我正在使用此函数将重音字符更改为基本字符。

Answer 1

解决了问题：

从双选择INITCAP(REPLACE(utl_raw.cast_to_archar2(nlssort('Chloé'，'nls_sort=binary_ai'((，CHR(0(，''(