Spanish accented special charactes issue

Posted on 2009-05-06
Last Modified: 2013-12-18

we have some perl scripts which loads similar data including spanish content from sybase 12.5 environmen into  two oracle 10g database servers say server A, Server B  (both running on unix AIX OS environment)

Server A has locale character set of en_US.UTF-8 which displays loaded spanish content without any issues when pointed by java application.

Server B was not set up for character set of en_US.UTF-8. Which does not display some of the spanish accented characters (which displays as some weird reverse '?' etc) when I point the application to this database server. How can i fix the issues on oracle database server B also so that when I point java application to it, it should display special accented characters fine similar to oracle database server A.

Can we install additional locale on server B like UTF-8?. How can we install additional locale on it

Any links, ideas, resources, sample code highly appreciated. Thanks in advance.



Question by:gudii9
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 11

Expert Comment

ID: 24315510
What operating systems are the servers?

Another possibility is to handle it in Oracle:

Oracle supports two methods for Unicode data storage. The first is known as the Unicode Database solution and involves creating a Unicode-based database using UTF-8 as the encoding not only for CHAR and VARCHAR2 character datatypes but also for all SQL names and literals. (CLOB is a special case here, as Oracle Database 10g always uses UTF-16 for CLOBs in a Unicode Database.) In order to implement the Unicode Database solution, configure your database character set as AL32UTF8, the Oracle name for UTF-8.

The alternative Unicode approach is the Unicode Datatype solution, in which UTF-16 data is stored in the NCHAR, NVARCHAR, and NCLOB Unicode datatypes. This is an ideal solution when you want Unicode support at the column level in a non-Unicode database. To implement this solution, set your national character set to AL16UTF16, the Oracle name for UTF-16. In fact, beginning with Oracle9I Database, using AL16UTF16 as the national character set is the default behavior.

Author Comment

ID: 24315596
both are on AIX unix operating system
LVL 11

Expert Comment

ID: 24315940
On the server that is the problem can you please get the output of

locale -a

and post it back here?
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.


Author Comment

ID: 24316080
it says like


LVL 11

Accepted Solution

kblack05 earned 500 total points
ID: 24316653
You can check if it has the specific file sets installed for the UTF-8 locale with

lslpp -l | grep -i locale

The file set in question should be contained in bos.loc.iso on the installer cd's.

To install: smitty -> System Environments -> Manage Language Environment -> Add Additional Language Environments

I believe it is on the 5th CD of 8 on the AIX install. But not certain.

Author Closing Comment

ID: 31578470
thank you very much

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have been pestered over the years to produce and distribute regular data extracts, and often the request have explicitly requested the data be emailed as an Excel attachement; specifically Excel, as it appears: CSV files confuse (no Red or Green h…
There are many situations when we need to display the data in sorted order. For example: Student details by name or by rank or by total marks etc. If you are working on data driven based projects then you will use sorting techniques very frequently.…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question