Skip to Main Content

SQL & PL/SQL

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!

Handling special Characters with sql loader

525708Sep 26 2007 — edited Sep 28 2007
Dear Members,

I am in process of loading data from an external file into a custom table in the database. The external file is a CSV file. The CSV file contains a lot of special characters like ╤ , Ñ , &. After loading into the table using sql loader these special characters are converted into ? or inverted question mark.

Sql loader is doing something which is converting the special characters. I want to load the special characters as it is in the database. How can i do that. How can we handle special characters using sql loader ?

Note : If i insert directly in to the table , then these special symbols are loaded as it is with out conversion.

It would be great if some body explains me in general how to handle these special characters with a control file if possible.

Our database is 10g and sql*loader version is 8.0.6.3.0

Thanks
Sandeep
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2007
Added on Sep 26 2007
2 comments
4,738 views