Configurating CharSet (á,é,í,ó,ú,ñ,Ñ,ü)

I have an Oracle server within a RS6000 (Unix). Normally I loggin in the machine, start sqlplus, do my queryes, and retrive the spooled data by FTP.
When I load the data into any windows application all works fine, and all special characters are correctly translated
All works fine there
BUT ...
When I use SQLPLUS for Windows, I get another characters, by example I get i instead é, m instead í, s instead ó.  

Where can I configure my Oracle Client instalation to get the correct characters ?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Check your registry parameters using regedit (W95) or regedt32 (WNT). Take a look to the following parameter located in the key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE:


This parameter must have the same value as the NLS_LANG of your Unix box plus the CHARACTER_SET you're using; for example:



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AbrahamFischerAuthor Commented:


I already found that registry key it is:
NLS_LANG      "NA"

What I want to know is what I have to put, your example is fine,
but where can I found that variable in the Linux Box ?
and how can I know which is the charset I'm using ?

Sorry, if my questions sounds silly, but I'm pretty new.

Connect to your oracle database and perform the following statement:

select * from v$parameter;

The output will show you many oracle parameters including character set, languages (NLS_LANG), date (NLS_DATE_FORMAT), etc.

Don't hesitate to contact me directly if you have any other question. My email address is
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.