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.