Re: Storing multilingual characters in Oracle
- From: Ana Choto <achoto@xxxxxxxxxxxx>
- To: dubey.sandeep@xxxxxxxxx
- Date: Fri, 29 Apr 2005 10:32:17 -0400
We had tons of problems with al32utf8 character set. Some applications
won't work with this character set. When we imported the data from our
production database to our 9i database created with al32utf8 lots or
records were not imported.
We ended up recreating our 9i database with WE8ISO8859P1 and UTF8 and we
haven't had any problems anymore.
PARAMETER VALUE
------------------------------ --------------
NLS_NCHAR_CHARACTERSET UTF8
NLS_CHARACTERSET WE8ISO8859P1
We have another 9i database with the default character set. But, as I said
before some of our application won't run here.
PARAMETER VALUE
--------------------------------------------------------------------------------
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET AL32UTF8
Thanks
Ana E. Choto
American University
e-Operations - Information Technology
Phone (202) 885-2275
Fax (202) 885-2224
Sandeep Dubey
<dubey.sandeep@gm
ail.com> To
Sent by: oracle-l@xxxxxxxxxxxxx
oracle-l-bounce@f cc
reelists.org
Subject
Storing multilingual characters in
04/29/2005 09:31 Oracle
AM
Please respond to
dubey.sandeep@gma
il.com
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:
1. Alter the columns to NCHAR. =20
2. Alter database charachter set AL32UTF8
3. Create a new database with AL32UTF8 charcter set and do export import.
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
