- 论坛徽章:
- 23
|
- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- SQL> desc t1;
- 名称 是否为空? 类型
- ----------------------------------------- -------- ----------------------------
- ID NOT NULL NUMBER(10)
- BID NUMBER(10)
- CONTENT CLOB
- OPERATE NUMBER(10)
- OPERATOR NUMBER(10)
- CREATETIME TIMESTAMP(3)
- TIMESTAMP RAW(8)
- SQL> desc t2;
- 名称 是否为空? 类型
- ----------------------------------------- -------- ----------------------------
- CONTENT VARCHAR2(4000 CHAR)
- SQL> select max(length(content)) from t1;
- MAX(LENGTH(CONTENT))
- --------------------
- 1671
- SQL> select max(dbms_lob.getlength(t1.content)) from t1;
- MAX(DBMS_LOB.GETLENGTH(T1.CONTENT))
- -----------------------------------
- 1671
- SQL> insert into t2 select content from t1;
- insert into t2 select content from t1
- *
- 第 1 行出现错误:
- ORA-64203: 目标缓冲区太小, 无法容纳字符集转换之后的 CLOB 数据。
- SQL> select userenv('language') from dual;
- USERENV('LANGUAGE')
- ----------------------------------------------------
- SIMPLIFIED CHINESE_CHINA.AL32UTF8
复制代码 为什么 4000 CHAR 装不下1671个字符? |
|