Re: nvarchar/nclob or varchar/clob

Michael Wimmer wrote:

> Hi,
>
> I need to store character data in an utf-8 database.
>
> I found the two possibilities of using either varchar2 and clob which
> uses 1 byte or 2 byte, depending on the character, or to use nvarchar2
> and nclob which always uses 2 byte.
>
> What would be the advantage/disadvantage of using nvarchar2 and nclob?
>
> Any recommendation is highly appreciated.
>
> Best regards,
>
> Michael

If it's an UTF8 database, there's no need to go nvarchar... Read the globalization manual of your version of oracle

-- 

Regards,
Frank van Bortel