National Language Support for Korean

From: <tkpnew_at_my-deja.com>
Date: Thu, 16 Sep 1999 04:58:40 GMT
Message-ID: <7rptdr$l91$1@nnrp1.deja.com>

We have a database instance with the database characterset as (CHARACTER SET WE8ISO8859P1 )

But Now we have to migrate our database to support a KOREAN representation. Since this KOREAN character is a multibyte (2 bytes per character), we created the database with the following database character and national character set configuration :
CHARACTER SET as KO16KSC5601 and
NATIONAL CHARACTER SET as KO16KSC5601 .

In the initialization parameter file , we set the NLS_LANGUAGE = KOREAN ,and

NLS_TERRITORY = KOREA In the SQL plus session through KOREAN WINDOWS SYSTEM , with this setup , We tried manipulating values for the given table structure with DEFINE NLS_LANG = KOREAN_KOREA.KO16KSC5601 . When we try to INSERT korean string
composed of two characters into a table having a column of datatype CHAR(2), it is giving an error "Ora - 01401 Inserted Value too Large for column".

So could you please suggest a solution , which would not involve any changes to the existing database design .

Thanks,
TKP Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 15 1999 - 23:58:40 CDT