Solved

Spanish accented special charactes issue

Posted on 2009-05-06
6
768 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

777 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