SEO

#1 (**permalink**) 02-24-2008, 03:23 PM

Hi,

I need to stored some japanese character in a WEISO8859P15 database.
But I prefer no migrate the SB character set to a MB character set.

Is it possible to store the asian character in CLOB in a SB database ?

tyia
rjp

#2 (**permalink**) 02-24-2008, 03:23 PM

It isn't.
P15 doesn't include any non-european characters.

--
Sybrand Bakker
Senior Oracle DBA

#3 (**permalink**) 02-24-2008, 03:32 PM

ok
thank you for your answer
Bye
RJP

#4 (**permalink**) 02-24-2008, 03:36 PM

On Fri, 5 Aug 2005 22:35:05 +0800, rjp wrote
(in article <1123252505.148627.102400@g14g2000cwa.googlegroups .com>):

> ok
> thank you for your answer
> Bye
> RJP
>

store the data in a BLOB, the data is not converted or played with by oracle.
The CLOB will do translation based on your database character setting.

#5 (**permalink**) 02-24-2008, 03:36 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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