Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Storing multilingual characters in Oracle
Our database currently storing english characters now needs to store
lanaguages like chinese, korean and Japanese. NLS_CHARACTERSET is
currently WE8ISO8859P1. I need to store multilingual characters in
approximately 20% of the tables. There are three options:
Are there any known issues of using Nchar on Oracle 9.2.0.4? I found on a metalink note recommending NOT to use nchar and rather change character set. Anyone has any bad experience with Nchar/Nvarchar2?
Is WE8ISO8859P1 a strict subset of AL32UTF8?=20
Or Option 3 is the best way to go. I am trying to avoid this option because of outage time I have to take for export and import.
Please share your experience.
Regards,
Sandeep Dubey
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 29 2005 - 09:46:11 CDT
![]() |
![]() |