Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Changing Database Character Set (Arabic????)

420414Jan 13 2006 — edited Jan 13 2006
Hello
I am facing an issue after changing the Database character set.
Steps followed
===========
1.My old database was Arabic Enabled.(Character set AR8ISO8859P6) which was in 8.1.5 Version.(Bought a New windows 2003 server and wanted to move the database)
2.Installed 8.1.7 version and Created a new database with default character set.(WE8ISO8859P1).Took the full export from the old and imported into the newly created database. My application was running fine but I could find all Question marks for the Arabic characters.(????)
3.Took the cold backup and full database export of the newly created database.(WE8ISO8859P1).
Deleted the above database and created a new database with AR8ISO8859P6 charactet set and imported into the currently created database with the full export dump.Still i am getting only question marks for the Arabic characters even after changing the database character set to AR8ISO8859P6.This is a Production database.It accepts new Arabic characters now but my Old data with Arabic Characters is still showing Question Marks(??????).

My Import Log
==========
Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8ISO8859P1 character set and AR8ISO8859P6 NCHAR character set
import server uses AR8ISO8859P6 character set (possible charset conversion)
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion).

Please advice.Any help is highly appreciated.What I need to do to get back my old Arabic data.(I will loose 15 days transactions if i need to import from my old Server) .
Regrads
Manoj
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2006
Added on Jan 13 2006
1 comment
556 views