I am using nvarchar2 data type to support multi language in my table for 10g oracle database.
I want to set it maxlength to 4000.
But my oracle database 10g supports only AL16UTF16 for NLS_NCHAR_CHARACTERSET which allow to set only nvarchar2 (2000).
I came to know that UTF8 supports nvarchar2 (4000) datatype.
Can any one please tell me how to set successfully this NLS_NCHAR_CHARACTERSET setting.
Thanks in advanced.