Special Characters getting replaced with  different characters

gsbharathi
gsbharathi used Ask the Experts™
on
We are getting problem while entering special characters like áéíóúñ into the OracleDatabase.
Oracle configured on windows NT or 2000 works fine but when configured on Linux the character is getting replaced with a different character
Eg.
while entering character ó it is getting replaced with o
Is it because of current linux server configuration supports ascii character range from 0-127.Should we make any changes to the configuration of linux or oracle.

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Trying to tame bits. They're nasty.
Commented:
This is an oracle matter.
First you should check what are the character sets that have been used to create the database. Second, you should configure your locale setting properly, the default locale is usually US 7-bit ASCII, which would behave exactly as you described.
If the database has been created with the proper character sets, everything else is just a matter of setting the proper shell variables. If the database has been created with US 7-bit ASCII then you'll either have to recreate the database or to convert it.
gsbharathi:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept comments from mbarbos as answer
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

TheWeakestLink
EE Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial