ORA-00910:指定的长度对于其数据类型而言太长 [英] ORA-00910: specified length too long for its datatype

问题描述

我在Oracle中有一列存储Nvarchar2(2000)的注释.当用户尝试输入超过2000个字符时，出现以下错误:

I have a column in Oracle to store comments of Nvarchar2(2000). When a user tries to enter beyond 2000 characters, I get the following error:

ORA-00910: specified length too long for its datatype.

NLS_NCHAR_CHARACTERSET参数具有AL16UTF16值.

是否可以增加大小以接受最多6000个字符?我的专栏已经有很多内容了，所以不确定我是否能够将数据类型从NVarchar(2000)更改为任何其他数据.

Is there any way to increase the size to accept up to 6000 characters? My column already has lots of contents, so not sure if I will be able to change the datatype from NVarchar(2000) to any other.

推荐答案

除非使用Oracle 12c，否则最多只能存储2000个字符，请参见此处的数据类型说明:

Unless you use Oracle 12c, it's not possible to store more than 2000 characters, see the datatypes description here:

http://docs.oracle.com/cd/B28359_01/server.111/b28320/limits001.htm

相反，您应该使用NCLOB数据类型.

Instead, you should use the NCLOB datatype.

如果您使用12c，请检查: http: //dbasolved.com/2013/06/26/change-varchar2-to-32k-12c-edition/

If you use 12c, check: http://dbasolved.com/2013/06/26/change-varchar2-to-32k-12c-edition/

这篇关于ORA-00910:指定的长度对于其数据类型而言太长的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！