Home » RDBMS Server » Server Administration » How to convert ISO-8859-1 charset data to UTF-8 charset data?
How to convert ISO-8859-1 charset data to UTF-8 charset data? [message #56481] Thu, 03 April 2003 01:39 Go to next message
Chandramoul9i
Messages: 2
Registered: April 2003
Junior Member
we have production data in some table fields which is in ISO-8859-1 charset in the oracle database.
Now we have to change this data into UTF-8 charset with out corrupting original production data.
How can we do this.

Report message to a moderator

Re: How to convert ISO-8859-1 charset data to UTF-8 charset data? [message #56495 is a reply to message #56481] Thu, 03 April 2003 13:33 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
The only way is to export the full db in WE8ISO8859P1, create new db instance with UTF8 character set, then setup NLS_LANG=lang_territory.WE8ISO8859P1 for the new UTF8 db and import.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: About character set translation!!!
Next Topic: how to avoid and see a fragment database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:38:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.