Oracle Community

The social network for Oracle people

Help Required (Load Special Characters through SQL Loader)

Hi All,

Please find below details. I am using Oracle 11g.

Records from CSV file:

AODEFH;FHG Süd

1)  I am trying to load above record through SQL Loader and I am getting below output in table

column1 value : AODEFH
column2 value : FHG S¿d

2) I am trying to load above record through insert statement and I am getting below output in table.

column1 value : AODEFH
column2 value : FHG Süd

I would like to know, How can I get same CSV row through SQL Loader in table? Which option from SQL Loader I should use?

Thanks in advance.

Regards,

Divyang

Views: 67

Reply to This

© 2013   Created by Eddie Awad.

Badges  |  Report an Issue  |  Terms of Service