Junk characters are inserted for Spanish alphabets by SQL Loader.
720461Oct 14 2009 — edited Oct 19 2009Hi all,
I am trying to load data into a data base table using SQL loader.Some of the data has Spanish alphabets.
The problem is that the SQL loader is misinterpriting them and inserting the Junk characters.
The version of SQL loader is : SQL*Loader: Release 8.0.6.3.0
The control file i am using is:
LOAD DATA
APPEND INTO TABLE XXBG.XXBG_PO_LINE_STG_TEST
fields terminated by "|" optionally enclosed by '"'
TRAILING NULLCOLS
(
PO_LINE_NUM
,ITEM_DESCRIPTION CHAR "TRIM (:ITEM_DESCRIPTION)"
,QUANTITY
)
The data is as follows:
1|COFFEE SPOONS / CUCHARAS PARA CAFÉ |12.00
Spanish alphabet is : É
Its is bening inserted as : COFFEE SPOONS / CUCHARAS PARA CAF¿
Can any body help me to fix this issue to load the Spanish alphabets successfully?
Thanks in advance.
Madhu Kumar