Dear all,
i'm trying to load Arabic data in the address in HRMS module in an external table : XX_Tbl_ALL_ADDRESSES (where ADD_INFORMATION13 & ADD_INFORMATION15 are the arabic )
-------------------------------------------------------------------------------------------------------
create table XX_Tbl_ALL_ADDRESSES
(
sn varchar2(200),
ADDRESS_LINE1 varchar2(200) ,
Country varchar2(200),
ADDRESS_LINE2 varchar2(200),
ADDRESS_LINE3 varchar2(200),
ADD_INFORMATION13 nvarchar2(200),
ADD_INFORMATION14 varchar2(200),
ADD_INFORMATION15 nvarchar2(200),
REGION number
)
and the CTL file is :
------------------------------
LOAD DATA
CHARACTERSET AR8MSWIN1256
append into table XX_Tbl_ALL_ADDRESSES
fields terminated by ',' optionally enclosed by '"'
TRAILING NULLCOLS
(
sn,
ADDRESS_LINE1,
Country ,
ADDRESS_LINE2,
ADDRESS_LINE3,
ADD_INFORMATION13,
ADD_INFORMATION14,
REGION ,
ADD_INFORMATION15
)
in regedit i changed the :
--------------------------------
NLS_lang to AMERICAN_AMERICA.AR8MSWIN1256
and
HKey_Local_Machine\System\CurrentControlSet\Control\NLS\CodePage\ ACP to 1256
the csv file is like :
| 89677,info,address1,test data,testing,العزبي,tetsing,العزبي,a |
but when i load the data using the SQL loader it doesn't work..
please advise how to save arabic CHAR in oracle table