Storing the UTF-8 strings

  • From: "Octavian Rasnita" <orasnita@xxxxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 3 Aug 2010 15:46:10 +0300

Hello,

I know that we could configure Oracle to accept UTF-8 strings in varchar2, 
nvarchar2, clob and nclob fields by setting the AL32UTF8 charset.

But I have also read that the varchar2 and clob field types are ment for 
storing 1-byte chars and that the nvarchar2 and nclob fields are for storing 
national character data.

But this is not clear enough. If I want to store UTF-8 strings, what should I 
use? varchar2 and clob, or nvarchar2 and nclob or it doesn't matter if I set 
AL32UTF8 for all these field types?

Thanks.

--
Octavian



__________ Information from ESET NOD32 Antivirus, version of virus signature 
database 5336 (20100803) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Other related posts: