-
max length for NVARCHAR2 data type
Hi gurus,
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?
Thanks!
Elaine
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|