Home » RDBMS Server » Server Utilities » Database Language
Database Language [message #221714] Wed, 28 February 2007 02:56 Go to next message
Ari00
Messages: 3
Registered: February 2007
Junior Member
Hi all,

I've got a problem with some especial characters, such as '˝' or 'ß' when I use the sqlldr. I've tried changing the session and instance language (put it into spanish) and the NLS_CHARACTERSET of de DB. If I make an insert from TOAD or sqlplus I don't have problems with this characters, and I tried 'select '˝' from dual' and all was correct.
I've got to load some unl files and I'm doing it with the sqlldr. Has anyone any idea about where is the problem and how should it be solved?

Thanks
Re: Database Language [message #221732 is a reply to message #221714] Wed, 28 February 2007 04:03 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Try to code "CHARACTERSET UTF8" in your control file and ensure you've set NLS_LANG for your session.
icon9.gif  Re: Database Language [message #221783 is a reply to message #221732] Wed, 28 February 2007 07:09 Go to previous message
Ari00
Messages: 3
Registered: February 2007
Junior Member
I tried what you said but it didn't work out well.
For example with the word 'CORUĐA', without specifying the CHARACTERSET in the ctl it was loaded as 'CORU?A', writing CHARACTERSET UTF8 it is loaded as 'CORU?'
Previous Topic: Date checking
Next Topic: SQL*Loader: Mutiple input files into multiple tables
Goto Forum:
  


Current Time: Wed Dec 07 03:08:21 CST 2016

Total time taken to generate the page: 0.08574 seconds