Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle SQL*Loader Encoding Issue for US7ASCII characterset in database for varchar2 type

Muskaan muskaanFeb 14 2025

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.

Comments

SiatGesi Feb 14 2025

THE FIRST problem howto wrap I have resolved…

SiatGesi Feb 14 2025

now I'm trying to move the unzipped files (pictures) from db to AS… my real problem… best regards

1 - 2

Post Details

Added on Feb 14 2025
0 comments
33 views