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!

Special Characters not loading properly

Ram CApr 4 2017 — edited Apr 5 2017

I have Oracle 11G (11.2.0.3) installation. I have two databases with the same character set: WE8ISO8859P1. I load the data from my application using sqlloader into the database. In one database, data is properly loaded. In the other database, the special characters are replaced with some junk characters.

My Column data:

SEEUP EPGDEPFR11 R 010GD802EPPC6YP1.Baro-VNAV Not Authorized Below -40°C (-40°F). 2.VPA 3.5° reached at 15°C. JS 466271704

Data in the problem database after loading:

SEEUP EPGDEPFR11 R 010GD802EPPC6YP1.Baro-VNAV Not Authorized Below -40¿C (-40¿F). 2.VPA 3.5¿ reached at 15¿C. JS 466271704

I tried changing the characterset to a superset: WE8MSWIN1252. But still the same issue while loading the data.

What are the basic things that I should check for. I tried comparing the two databases, but no specific parameter difference that I can find which could be of help. Please help me further.

Thanks

Ram

Locked Post

New comments cannot be posted to this locked post.

Locked on May 3 2017

Added on Apr 4 2017

#database-key-features, #export-import-sql-loader-external-tables

8 comments

1,682 views