2 Replies Latest reply: Mar 5, 2013 6:54 PM by Sergiusz Wolicki-Oracle RSS

    Arabics Characters dispalyed as ???

      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.