I am having a problem with the data encoding in Oracle. Initially my database was of 10g with UTF8 character set(in Solaris server). Then I created a 11g database in Linux server with AL2UTF8 character set and imported the dump from my 10g database in this 11g database.
In my 10g database I had some Spanish characters and after changing to 11g, I am not able to view this characters. While selecting these entries using sqlplus I am getting a ? symbol and while selecting using sql developer I am getting a square symbol in place of these characters.[My application also shows some weird characters]
I tried inserting these characters into the new database using sqlplus and sql developer and interestingly both are visible in that case. Therefore it will be a tedious job for me to find out the characters in the database and add those again. Can you please advise a way such that the characters will be visible in my application(developed in c++ and running in Linux) without reinserting the records again?