What is the maximum length of nvarchar2 in Oracle?

5 months ago

1 minute

In Oracle databases, the NVARCHAR2 data type is used to store variable-length strings in the Unicode character set. The maximum length of the NVARCHAR2 data type depends on the database version and configuration.

In general, for Oracle 12c and higher versions, the maximum length of the NVARCHAR2 data type is 32767 characters. In Oracle 11g and earlier versions, the maximum length of the NVARCHAR2 data type is typically 4000 characters.

Please note that the actual maximum length may be influenced by other factors such as tablespace limits, column width limits, etc. It is recommended to refer to the appropriate version of the Oracle documentation to confirm the exact maximum length limitation.