ORA-00910: specified length too long for its datatype
来源:互联网 发布:网络预约出租车驾驶员 编辑:程序博客网 时间:2024/06/05 07:14
ORA-00910: specified length too long for its datatype
//z 2012-08-01 13:37:33 IS2120@CSDN.T3072156621[T5,L58,R1,V32]
oracle column (field) size NVARCHAR2 大小限制
当 NLS_NCHAR_CHARACTERSET 为 AL16UTF16 的时候,最大能设置为2000
当 NLS_NCHAR_CHARACTERSET 为utf8 的时候,最大能设置为4000
这是因为NVARCHAR2数据类型,最大只能存储4000个字节。
//z 2012-08-01 13:37:33 IS2120@CSDN.T3072156621[T5,L58,R1,V32]
CHAR, NCHAR, VARCHAR2 and NVARCHAR2
Character data types store character data in the database character or national character set.
CHAR[(n [BYTE |CHAR] )]
Fixed-length character data of length n bytes or characters. The maximum length is 2000 bytes, the default value is 1.
BYTE indicates that the length semantics for the column is byte. CHAR indicates that the length semantics for the column is character. The default is BYTE. CHAR and BYTE qualifiers are not available prior to Oracle Version 9.
NCHAR[(n)]
Fixed-length character data of length n characters or bytes, depending on the national character set. The maximum length is determined by the number of bytes required to store each character, with an upper limit of 2000 bytes. The default value is 1.
VARCHAR2(n [BYTE |CHAR] )
Variable-length character data with length of n characters. The maximum length is 4000 bytes. You must specify the maximum length for VARCHAR2 columns.
BYTE indicates that the length semantics for the column is byte. CHAR indicates that the length semantics for the column is character. The default is BYTE. CHAR and BYTE qualifiers are not available prior to Oracle Version 9.
NVARCHAR2(n)
Variable-length character data having maximum length n characters or bytes, depending on the national character set. The maximum length is determined by the number of bytes required to store each character, with an upper limit of 4000 bytes. You must specify the maximum length for NVARCHAR2 columns.
- ORA-00910: specified length too long for its datatype
- warning: character constant too long for its type
- Specified key was too long; max key length is 767 bytes
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- MySQL错误“Specified key was too long; max key length is 1000 bytes”
- hive的Specified key was too long; max key length is 767 bytes问题解决
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- MySQL错误“Specified key was too long; max key length is 1000 bytes”的解决办
- 错误代码: 1071 Specified key was too long; max key length is 1000 bytes
- MySQL错误“Specified key was too long; max key length is 1000 bytes”的解决办法
- Specified key was too long; max key length is 767 bytes问题
- mysql [Err] 1071 - Specified key was too long; max key length is 767 bytes
- MySQL:Specified key was too long; max key length is 767 bytes
- MySQL错误“Specified key was too long; max key length is 1000 bytes”的解决办法
- Specified key was too long; max key length is 767 bytes
- Specified key was too long; max key length is 767 bytes
- hive的Specified key was too long; max key length is 767 bytes问题解决
- hive的Specified key was too long; max key length is 767 bytes问题解决
- Oracle查看索引语句
- 带你了解中国互联网发展报告
- js 遍历json
- hdu 1058 Humble Numbers
- Oralce的Sql语名性能分析
- ORA-00910: specified length too long for its datatype
- 怎样合理地规划使用电脑硬盘
- Android项目之——Activity悬浮并可拖动
- android高手成长之路--怎样成为编程高手
- linux服务器监控命令
- poj 3368 Frequent values#线段树
- linux 下软键盘的弹出与隐藏
- switch-case语句用法
- the superiority of ARM Cortex-M3