Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> character set migration
Hi,
I encountered the demand to store the euro sign. With the current character
set impossible.
So I have to migrate to a new one. Docs state
alter database character set is possible when new character set is a
superset.
Alternative is to export and import which is not a realistic at this time
for this organization.
I have 2 questions:
1) My current character set is WE8ISO8859P1, I understood WE8ISO8859P15 does
contain the euro
sign but is this a superset?
2) Any experiences with alter database character set? Is this a solution
without risks? I have about 3 tables
with either long or clob type fields so I might have to export and import
those only, but these are not about currencies so
should I export those?
Hope you can shed some light on this,
Tnx,
Jeroen
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 04 2005 - 10:17:15 CST
![]() |
![]() |