Re: LOB problem

You can set two languages in the database, the default and a 'national language'. I've not actually played about with it,so I'm, not sure of the details, but if you set the national language to a fixed width character set I believe you can then use NCLOBs in your database instead of CLOBS.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Dennis wrote in message <880lg9$m4p$1_at_news.seed.net.tw>...
>Dear all,
> I tried to create a table with a CLOB column, but the Oracle server
>show me the ORA-22866 error code. The following is the detail of the code:
>
> 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.
>
> The character set (Traditional Chinese) of my Database is of varying
>width instead of fixed width. That's why I can not create. I wonder if it
>means I can not use the LOBs on my existing Database, or there is a way to
>solve this problem. Thanks in advance.
>
>Best Regards
>Dennis
>
>
Received on Fri Feb 11 2000 - 05:13:06 CST