Home » RDBMS Server » Server Utilities » SQL Loader is not uploading non-ASCII characters (Oracle 10g)
SQL Loader is not uploading non-ASCII characters [message #538963] Tue, 10 January 2012 09:21 Go to next message
Oracle_Walker
Messages: 71
Registered: January 2012
Location: United States
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
Re: SQL Loader is not uploading non-ASCII characters [message #538976 is a reply to message #538963] Tue, 10 January 2012 10:50 Go to previous message
Michel Cadot
Messages: 68624
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 Mar 28 06:13:19 CDT 2024