• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1890
  • Last Modified:

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 ?
  • 2
1 Solution
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:


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 jmponcemartinez@hotmail.com
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now