Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Changing NCHAR set

RE: Changing NCHAR set

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Thu, 21 Apr 2005 20:17:31 +0200
Message-ID: <7F0C000A3ABA6241A10C9ABF37EEB46D0406B2@MSXVS01.trivadis.com>


Hi

>I have got a database that was set up with AL32UTF8=20
>character set and AL16UTF16 NCHAR Char Set. =20
>Is there an easy way to just change the NCHAR set to UTF8?

In the Globalization Support Guide you find some information about = character set migration.

However, if few columns use NCHAR, it's probably quite easy to change = their datatype to CHAR (or NVARCHAR2 to VARCHAR2).

Another info... you should use AL32UTF8 instead UTF8.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 21 2005 - 14:21:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US