NVARCHAR(MAXSIZE)
来源:互联网 发布:php预约管理系统 编辑:程序博客网 时间:2024/06/06 05:18
昨日上线个表 其中好多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
- NVARCHAR(MAXSIZE)
- 数据文件 maxsize
- struts.multipart.maxSize
- golang glog maxsize
- maxmimumsize 和struts.multipart.maxSize
- ORA-00904: “MAXSIZE”: invalid identifier
- ORA-00904: "MAXSIZE": invalid identifier
- Struts2中struts.multipart.maxSize设置
- Struts2中struts.multipart.maxSize设置
- 解决Consider increasing spark.rpc.message.maxSize
- Struts2中struts.multipart.maxSize设置
- varchar nvarchar
- varchar nvarchar
- VARCHAR/NVARCHAR
- NCHAR、NVARCHAR
- NVARCHAR & VARCHAR
- varchar nvarchar
- 设置maxsize的自动扩展数据文件在达到maxsize后是否会继续扩展
- 中断_相关函数比较
- ARM9和Linux的嵌入式打印终端系统
- gridview匯出excel(html版)
- oracle函数大全(比较全面)
- 四种进程或线程同步互斥的控制方法
- NVARCHAR(MAXSIZE)
- Instruments使用小记(2012-11-28更新)
- 消息系统架构设计
- IOS TableView 数据列表与设置页面(个人)
- Error: Connection activation failed: Device not managed by NetworkManager
- 开始我的博客之旅
- 开始学习Sencha Touch
- Kmp算法的两种写法
- 我是个宅男,天天就想着美女---Android app>>Girl Style看过来