max length for NVARCHAR2 data type
Oracle doc clearly specifies that
Width specifications of character datatype NVARCHAR2 refer to the number of characters if the national character set is fixed width and refer to the number of bytes if the national character set is variable width. The maximum column size allowed is 4000 bytes.
However, when I tried to create a table with NVARCHAR2 column in my database, I can't speicify the width over 2000. Once it's over 2000, I will get a message said
ORA-00910: specified length too long for its datatype
I wonder is that because my Oracle database's default character set is fixed double byte? How can I check that?
Click Here to Expand Forum to Full Width