Re: Storing the UTF-8 strings
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: orasnita@xxxxxxxxx
- Date: Tue, 3 Aug 2010 15:46:36 +0200
Octavian,
if you set the character set to AL32UTF8 you can store UTF-8 in
varchar2 and clobs.
Please make sure you set the correct NLS_LANG on the clients side!
(e.g. if the client reads and writes WIN1252, set NLS_LANG correct!)
Oracle characterset handling is not easy, but it's consistent and working.
br
Martin
2010/8/3 Octavian Rasnita <orasnita@xxxxxxxxx>:
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
