When inserting ᄏᄏᆲᄡᄆ for varchar2 type in Unicode characters into an Oracle US7ASCII database:
- Java JDBC program inserts the correct values.
- SQL*Loader (
**sqlldr**
) replaces characters with **?**
.
Environment Details:
- Database Charset:
US7ASCII
- JDBC Insert: stores correct value verify by seeing SELECT DUMP(column name) it returns correct hex value.
- SQL*Loader : Stores
??
- Tried NLS_LANG & CHARACTERSET:
UTF8
, WE8ISO8859P1
, US7ASCII
(but it didnt resolve the issue)
How to make sqlldr work with this value , what config do i need to change from my end.