I am having a problem with the data encoding in Oracle. Initially my database was of 10g with UTF8 character set. Then I created a 11g database with AL2UTF8 character set and imported the dump from my 10g database in this 11g database.
In my 10g database I had some special characters and after changing to 11g, I am not able to view this characters. While selecting these entreis using sqlplus I am getting a ? symbol and while selecting using sql developer I am getting a square symbol in place of thse characters.
I tried inserting these charcters into the new database using sqlplus and sql developer and interestingly both are visible in that case. Therefore it will be a tideous job for me to find out the characters in the database and add those again. So can anyone advise a way such that the characters will be visible without manually doing anything.