OraFAQ Forum: Server Utilities » SQL Loader is not uploading non-ASCII characters

Home » RDBMS Server » Server Utilities » SQL Loader is not uploading non-ASCII characters (Oracle 10g)

Tue, 10 January 2012 09:21

vel4ever
Messages: 29
Registered: January 2012
Location: India

Junior Member

I am using SQL Loader to load data from text file to DB. non-ASCII characters present in the text file is not uploaded correctly to DB.

Sample Data

test data üindex

Data in DB

test data ?index

Tue, 10 January 2012 10:50

Michel Cadot
Messages: 54201
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Text file character set must match database character, or be compatible with database character and you have to use the CHARACTERSET.
Also read Handling Different Character Encoding Schemes

Regards
Michel

Previous Topic:	Issue while using sequence in sqlloader
Next Topic:	Evaluate export dump size

Goto Forum:

]

Current Time: Thu May 23 03:35:11 CDT 2013

Total time taken to generate the page: 0.13022 seconds