Changing Database Character Set (Arabic????)
420414Jan 13 2006 — edited Jan 13 2006Hello
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