Solved

Spanish accented special charactes issue

Posted on 2009-05-06
6
776 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
  • 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

Technology Partners: 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

Suggested Solutions

Title # Comments Views Activity
Oracle collections 15 37
error in my cursor 5 50
Oracle Distributed Transaction Lock Error ORA-01591 8 68
add more rows to hierarchy 3 33
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to recover a database from a user managed backup

735 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