i install a new oracle 9i database with NLS_CHARACTERSET=AL32UTF8. i import a dmp file from a database source that's have the same CHARACTERSET.
AMERICAN_AMERICA.AR8MSWIN1256 is the value of NLS_LANG on the database source and destination.
i deploy a application based on forms10g.
i can see correctly the arabics characters imported on my forms and via sql navigator and sqlplus.
i can see them correctly when i make a new insert on tables throught forms or via sqlplus.
i set nls_lang on my new machine as AMERICAN_AMERICA.AR8MSWIN1256 and i choose arabic language for regional setting.
my problem is whe i try to export data from forms to excel file the arabics characters are dispalyed like ??????
i don't understand if it's a probleme of NLS_LANG or NLS_CHARACTERSET ?
any help plze.