NVARCHAR(MAXSIZE)

昨日上线个表 其中好多NVARCHAR2字段 其中一个设置了3000 结果无法建表. 虽然在开发库OK

  SH_REMARK            NVARCHAR2(3000),

官方文档如此说

The maximum column size allowed is 4000 characters when the national character set is UTF8 and 2000 when it is AL16UTF16. The maximum length of an NVARCHAR2 column in bytes is 4000.

意思是 如果国家字符集是UTF8 那就是4000 如果是UTF16那是2000  BYTES总大小4000 

SQL> select * from v$nls_parameters where parameter like 'NLS%';
 
PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_LANGUAGE                                                     AMERICAN
NLS_TERRITORY                                                    AMERICA
NLS_CURRENCY                                                     $
NLS_ISO_CURRENCY                                                 AMERICA
NLS_NUMERIC_CHARACTERS                                           .,
NLS_CALENDAR                                                              GREGORIAN
NLS_DATE_FORMAT                                                         DD-MON-RR
NLS_DATE_LANGUAGE                                                   AMERICAN
NLS_CHARACTERSET                                                      AL32UTF8
NLS_SORT                                                                            BINARY
NLS_TIME_FORMAT                                                            HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT                                                DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT                                                      HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT                                          DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY                                                   $
NLS_NCHAR_CHARACTERSET                                      AL16UTF16
NLS_COMP                                                                           BINARY
NLS_LENGTH_SEMANTICS                                             BYTE
NLS_NCHAR_CONV_EXCP                                              FALSE