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

Report message to a moderator

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: 4587
Registered: April 1998
Senior Member
Try to code "CHARACTERSET UTF8" in your control file and ensure you've set NLS_LANG for your session.

Report message to a moderator

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?'

Report message to a moderator

Previous Topic: Date checking
Next Topic: SQL*Loader: Mutiple input files into multiple tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 20:56:49 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.