the answer from metalink
====================================================================
ORA-22866 default character set is of varying widthCause: A character LOB was defined but the default character set is not fixed width.Action: Ensure that the character set is of fixed width before defining character LOBs.
====================================================================
ORA-22866 default character set is of varying widthCause: A character LOB was defined but the default character set is not fixed width.Action: Ensure that the character set is of fixed width before defining character LOBs.
1、数据库: Oracle 8i R3 (8.1.7) for NT 企业版说明: CLOB字段可以select,但select时不可以使用where
SQL> create table a(a clob);SQL> insert into a values('1234');SQL> insert into a values('5648');SQL> select *from a; 12345648
CLOB字段可以select,select时也可以使用whereSQL> create table tbl2(a clob);表已创建。insert into tbl2 values('134444')SQL> select * from tbl2 where a like '13%';A
--------------------------------------------
134444
134444
134444
svrmgrl
SVRMGR>startup mount
SVRMGR>alter system enable restricted session;
SVRMGR>alter system set job_queue_processes=0;
SVRMGR>alter database open;
SVRMGR>alter database character set ZHS16GBK;
SVRMGR>shutdown
SVRMGR>startup