Hi all,
I'm facing a problem handling Greek characters while inserting into a Oracle table.
control file :
LOAD DATA
CHARACTERSET UTF8
APPEND
INTO TABLE Repository_Owner.PFORCE_TEMP_EMP
WHEN COUNTRY_CD='GR'
FIELDS TERMINATED BY "|"
TRAILING NULLCOLS
(
COUNTRY_CD CHAR NULLIF(COUNTRY_CD = BLANKS),
SOURCE FILLER,
SRC_SYS_ID CHAR NULLIF(SRC_SYS_ID = BLANKS),
LOGIN_ID CHAR NULLIF(LOGIN_ID = BLANKS),
FRST_NM CHAR NULLIF(FRST_NM = BLANKS),
LAST_NM CHAR NULLIF(LAST_NM = BLANKS),
EMAIL CHAR NULLIF(EMAIL = BLANKS),
LAST_UPD_TS DATE "YYYY-MM-DD HH24:MI:SS" NULLIF(LAST_UPD_TS = BLANKS),
ACTIVE CHAR "DECODE(:ACTIVE,'TRUE','Y','FALSE','F',NULL)"
)
When inserting flat file data through sql loader wizard , I'm seeing ???? instead of data in table.Please give a solution to handle Greek characters.
TIA ;)