Solved

Spanish accented special charactes issue

Posted on 2009-05-06
6
780 Views
Last Modified: 2013-12-18
Hi,

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.

 

 .

0
Comment
Question by:gudii9
[X]
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
6 Comments
 
LVL 11

Expert Comment

by:kblack05
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.
0
 
LVL 7

Author Comment

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

Expert Comment

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

locale -a

and post it back here?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 7

Author Comment

by:gudii9
ID: 24316080
it says like
POSIX

C

iso_8859_1
0
 
LVL 11

Accepted Solution

by:
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.
0
 
LVL 7

Author Closing Comment

by:gudii9
ID: 31578470
thank you very much
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

759 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