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

Home -> Community -> Usenet -> c.d.o.server -> Re: Using Asian Character within CLOB in a single-byte database character set

Re: Using Asian Character within CLOB in a single-byte database character set

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 8 Aug 2005 23:26:38 -0700
Message-ID: <1123568798.738015.92900@f14g2000cwb.googlegroups.com>


Look at NLS_NCHAR_CHARACTERSET. If this is any of the Unicode charactersets (likely AL16UTF16 in Oracle 9, but UTF8 or AL32UTF8 too) you can store japanese in NCHAR, NVARCHAR2 or NCLOB columns. If not, try blob or raw datatypes.

Hth.

Cheers.

Carlos. Received on Tue Aug 09 2005 - 01:26:38 CDT

Original text of this message

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