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

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

Tue, 10 January 2012 10:50

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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: Fri May 08 10:51:35 CDT 2026