OraFAQ Forum: Reports & Discoverer » Database value with Arabic , english letters and digits

Home » Developer & Programmer » Reports & Discoverer » Database value with Arabic , english letters and digits (Oracle Reports 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database value with Arabic , english letters and digits [message #625293]

Sat, 04 October 2014 03:11

smjohn
Messages: 4
Registered: September 2014

Junior Member

Hi,

I have database field( item name) which has some arabic text along with English alphabets and english numerals.
when displayed in the oracle report(pdf)10g, the arabic is correct but the english alphabets and digits get jumbled.I have used Arial font.and in the registry nls_lang is ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256

eg. حبر طابعة ريكو اسود AP600N

is displayed in ,my report as حبر طابعة ريكو اسود N600AP.

please suggest a solution

Report message to a moderator

Re: Database value with Arabic , english letters and digits [message #625298 is a reply to message #625293]

Sat, 04 October 2014 06:28

shahzad-ul-hasan
Messages: 640
Registered: August 2002

Senior Member

Have you Set your data base default language to AL32UTF.
Quote:

These are the character set for oracle database.
US7ASCII, WE8ISO8859P1, and WE8MSWIN1252 into a WE8MSWIN1252 CDB
WE8ISO8859P15 into a WE8ISO8859P15 CDB
JA16SJISTILDE into a JA16SJISTILDE CDB
JA16EUC into a JA16EUC CDB
KO16KSC5601, KO16MSWIN949 into a KO16MSWIN949 CDB
UTF8 and AL32UTF8 into an AL32UTF8 CDB

If not then See this article.
https://community.oracle.com/thread/992007

[Updated on: Sat, 04 October 2014 06:29]

Report message to a moderator