| Database Language [message #221714] |
Wed, 28 February 2007 02:56  |
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 #221783 is a reply to message #221732] |
Wed, 28 February 2007 07:09  |
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?'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
