Problems with character set in Export-Import database
I have got a database oracle 8.1.7 with character set AMERICAN_AMERICA.US7ASCII.
I exported the database with:
export NLS_LANG=AMERICAN_AMERICA.US7ASCII
exp effenerg/xxxxx@aegg file=exp_effenerg.dmp FULL=y log=zexp.log
On another machine, i have got a database oracle 10.2.0.4 with AMERICAN_AMERICA.WE8MSWIN1252
I imported the 8i database in this 10g database with:
export NLS_LANG=AMERICAN_AMERICA.US7ASCII
imp system/yyyy@aegg file=exp_effenerg.dmp fromuser=effenerg touser=effenerg log=imp.log
After import, i noted that all the characters "à", "ò", "ù", "è", "ì" was importing with character "?"