Click here to Skip to main content
15,891,513 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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 ;)
Posted

1 solution

Did you try using NVARCHAR while define your variables?
Sample: FRST_NM NVARCHAR ...
 
Share this answer
 
Comments
vamsi.welcome 7-Jul-14 9:13am    
Ya, table column data type is NVARCHAR2
FRST_NAME NVARCHAR2(150)
I am using Oracle through Toad tool, these are the following NSL character variables of my client version
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16
Issue is still open , please suggest a solution.
vamsi.welcome 30-Jul-14 8:33am    
Can somebody look into this and provide me hints

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900