This discussion is archived
2 Replies Latest reply: Mar 5, 2013 4:54 PM by Sergiusz Wolicki (Oracle) RSS

Arabics Characters dispalyed as ???

933201 Newbie
Currently Being Moderated
dear all,
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.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points