Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Arabic Character while loading in to Oracle.

385862Oct 15 2003 — edited May 30 2006

Hi All,
OWB config is as follows:
OWB : 9.2
Oracle 9i database.

I am able to load Arabic characters from a source table to a target table
using OWB mappings but when i try to load a flat file the characters get jumbled.

My environment variables :--
IN
Database character set AR8ISO8859P6
Database National character set AL16UTF16
Database NLS_language AMERICAN
Database NLS_territory America
all settings obtained from v$nls_parameters

ON Windows server
in registry
NLS_LANG = AMERICAN_AMERICA.AR8MSWIN1256

I have tried changing the NLS_LANG in the registry to AR8ISO8859P6 but still
the same results.

Does OWB support Arabic character, by default at time of installation i must have selected American as language parameter?

If ans to above query is 'Yes' & it i manage to set Language to Arabic what will be impact on other components e.g. OEM, OWM etc.
Thanks in Advance.
Regards,
Vidyanand

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2006

Added on Oct 15 2003

#data-warehousing, #warehouse-builder

9 comments

2,068 views