HP Support Forums

Join in the conversation.

Search the Community
turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
This HP Community is for Customer to Customer Product Support. First Time Here? Check Out Videos on How to Search, Register, Post and More.

UTF8 characters not showing correctly after changing HPUX server from PA-RISC to Itanium (84 Views)
Reply
Reply
Topic Options
FrankMP Student
Student
FrankMP
Posts: 1
Registered: ‎07-27-2012
Message 1 of 1 (84 Views)
Report Inappropriate Content

UTF8 characters not showing correctly after changing HPUX server from PA-RISC to Itanium

‎07-27-2012 12:34 AM

We changed our server from HPUX PA-risc 64-bit to HPUX 64-bit Itanium:  B.11.31 U ia64

We have in both computers the following locale:

LANG=
LC_CTYPE="C"
LC_COLLATE="C"
LC_MONETARY="C"
LC_NUMERIC="C"
LC_TIME="C"
LC_MESSAGES="C"
LC_ALL=

and we have this environment variable set: $ echo $NLS_LANG
AMERICAN_AMERICA.AL32UTF8

Initially, we had the same problem in the PA-RISC system until we defined the NLS_LANG variable.

Now, in the Itanium system, the NLS_LANG variable doesn't help. The utf8 characters coming from the Oracle database that are displayed using sqlplus are represented with several occurrences of ctrl-Z. I verified that the special characters are loaded correctly in the database, and they display fine using SQL Developer.

I have to say also that at the same time we changed our server, we upgraded Oracle from version 10g to 11g (11.2.0.2).

Have you heard of this issue with Itanium servers?

Thank you for your help.

0
Reply
0
Please use plain text.