Handling special Characters with sql loader
525708Sep 26 2007 — edited Sep 28 2007Dear 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