Character length semantics
I set nls_length_semantics = 'CHAR' for Oracle 9i database, the character set is 'AL32UFT8', I assumed it stored characters based on number of Unicode unit instead of number of bytes base on the Oracle menu, however it seems not working when I try to load Japanese into it.
Create table test (
It allowed me to insert 80 Japanese characters into test.name, but it will fail over 80 Japanese characters.
Click Here to Expand Forum to Full Width