Home » SQL & PL/SQL » SQL & PL/SQL » How to load special characters into oracle database (Oracle 10g)
How to load special characters into oracle database [message #330669] Mon, 30 June 2008 13:59 Go to next message
dsean
Messages: 5
Registered: March 2006
Junior Member
Hi,
We have Oracle 10g database and I am loading the company information into one of the table. In some cases we get GERMAN characters as part of the Column value in names and Address. Currently I am loading using SQLLdr scripts and it is inserting unrecognizable character. Can anyone please suggest how to handle these german characters. Do I need to setup anything to take care of these??

Eg: café is loading as caf¿..

Thanks in advance,
Sean.

Re: How to load special characters into oracle database [message #330670 is a reply to message #330669] Mon, 30 June 2008 14:04 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

What is the character set of the database?
What is the character set of the client?

EXACTLY how are you getting "caf¿"?
Re: How to load special characters into oracle database [message #330672 is a reply to message #330669] Mon, 30 June 2008 14:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to ensure that all character sets you set between the file/client/server/database support the characters you want.

Regards
Michel
Re: How to load special characters into oracle database [message #330675 is a reply to message #330670] Mon, 30 June 2008 14:34 Go to previous message
dsean
Messages: 5
Registered: March 2006
Junior Member
Thanks for your prompt replies..

The database character set is WE8ISO8859P1. i don't know about the Character set of the client. Can anyone please tell me how to view these? right now I am loading the data from an EXCEL sheet into oracle table by ftping the EXCEL onto Database server.

Sean.
Previous Topic: Scheduling stored procedure (merged)
Next Topic: using Spool in procedure
Goto Forum:
  


Current Time: Sun Dec 04 15:02:39 CST 2016

Total time taken to generate the page: 0.19510 seconds