Database characterset and character set in UNIX
836476Apr 28 2011 — edited May 10 2011The DB character set for my application is AL32UTF8.Some fields in the table contain special characters like á ® ¢ £ © ½ ²° .
A job runs in UNIX box which queries the table and fetches the result.But these special characters are not getting recognized and are displaying as '?'.
Then, I had set the character set in UNIX box for a session alone as export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
Now the output comes with the special characters, but with extra symbol like ® , ¢ , £ , © .
I then tried changing it to export NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252 .Now the output is coming as expected.
i) Why is this extra symbol  coming when i use AL32UTF8 in the UNIX side ?
ii) What would be a problem if the DB character set is AL32UTF8 and the character set in the UNIX is WE8MSWIN1252 ?
iii) Also there is a character set been put up for Application/Forms server in the same UNIX box as AL32UTF8.Suppose the session character set is WE8MSWIN1252 ,will it overwrite the character set that is present for the forms server?
DB: Oracle 10g
Please help me on this .