系统平台: window2003
数据库版本:oracle8.17
问题: 建立带有clob类型的字段时都会出现"ORA-22866 默认字符集具有不同的宽度",普通字段则好好的.不知什么原因,特来救助.
---------------------------------------------------------------
Metalink
You are attempting to create a table with a CLOB column, and it fails
with the following error:
ORA-22866: default character set is of varying width
Cause: 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.
This may also occur on import when importing from a table that has a
CLOB column.
Solution Description
--------------------
The compatible parameter for your database is set to 8.0.5 (or lower).
Edit the init.ora parameter file with a compatible parameter of
8.1.0 or higher.
Explanation
-----------
Your database has a character set of UTF8, a variable width character set.
In versions previous to Oracle8i, this restricted the use of CLOB datatypes.
---------------------------------------------------------------