CREATE TABLE customer1(cid BIGINT NOT NULL PRIMARY KEY, info XML);
log:
------------------------------ Commands Entered ------------------------------
CREATE TABLE customer1(cid BIGINT NOT NULL PRIMARY KEY, info XML);
------------------------------------------------------------------------------
CREATE TABLE customer1(cid BIGINT NOT NULL PRIMARY KEY, info XML)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1239N XML features can only be used in a Unicode database with a single
database partition. SQLSTATE=42997
SQL1239N XML features can only be used in a Unicode database with a single database partition.
结果在网上看到如此的内容:
DB2 V9创建具有XML字段时的一个注意点(数据库需要UTF-8编码)
这是因为数据库本身不是Unicode导致的。正确步骤如下:
1. 创建一个UTF-8数据库:
create db test using codeset UTF-8 territory us;
2. 创建相应的表:
create table dept1(id int, doc xml);