Re: can't create table with clob datatype?

In article <964vpa$kon$1_at_news.seed.net.tw>,   "Ron" <ronyin_at_tpts5.seed.net.tw> wrote:
> i'm new to oracle.
> i installed oracle8.0.5 on IBM SP2.
> i created a database with ZHT16BIG5 character set.
>
> I create a table by using SQLPLUS.
> username:scott
> passwd:tiger
> SQL> CREATE TABLE Tbl (col1 clob, col2 clob, col3 clob);
> ERROR at line 1:
> ORA-22866: default character set is of varying width
>
> i got a error with scott/tiger id.
> but i had no problem with system/manager id.
> can anyone help me to solve the error ORA-22866.
>
> Ron
>

I do not have any experience working with multi-byte character sets but according to the Concepts manual CLOB and NCLOB are for single byte character set and fixed-length multi-byte character sets respectively. Apparently your database character set is variable. You may need to talk to support if no experienced multi-byte character set users post.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com
http://www.deja.com/