Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

special character showing as upside down question mark on oracle report

user13118348Feb 4 2011 — edited Feb 4 2011
We have an oracle report which selects data from a database table. Report shows a name field and names with a special character is showing as upside down question mark.

The name is Simon John ễễ BaileyŠğčẫ

But when we run the oracle report the name is showed with 6 upside down question marks

I am not sure if these characters are unicode? (beyond western european character set)

Oracle database: 11.2.0.1 with nls_characterset = AL32UTF8
Oracle Reports Server: 10.1.2.3.0 with the following locale settings:

LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=


Any ideas, suggesstions, is this font related issue?

Thanks for your help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2011
Added on Feb 4 2011
2 comments
711 views