nvarchar/nclob or varchar/clob

From: Michael Wimmer <newsgroup1_at_ecom.at>
Date: Thu, 28 Oct 2004 11:34:14 +0200
Message-ID: <4180bd5b$0$21380$91cee783@newsreader02.highway.telekom.at>

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 Received on Thu Oct 28 2004 - 04:34:14 CDT