Home » Developer & Programmer » Reports & Discoverer » Database value with Arabic , english letters and digits (Oracle Reports 10g)
Database value with Arabic , english letters and digits [message #625293] Sat, 04 October 2014 03:11 Go to next message
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
Re: Database value with Arabic , english letters and digits [message #625298 is a reply to message #625293] Sat, 04 October 2014 06:28 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 561
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

Re: Database value with Arabic , english letters and digits [message #625310 is a reply to message #625298] Sat, 04 October 2014 23:06 Go to previous messageGo to next message
smjohn
Messages: 4
Registered: September 2014
Junior Member

The database with the current character set is running perfectly with old application (forms 5) .Is there any other solution?
Re: Database value with Arabic , english letters and digits [message #625646 is a reply to message #625310] Sun, 12 October 2014 06:16 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 561
Registered: August 2002
Senior Member
What form/reports version you are using.
Re: Database value with Arabic , english letters and digits [message #625648 is a reply to message #625646] Sun, 12 October 2014 06:36 Go to previous message
smjohn
Messages: 4
Registered: September 2014
Junior Member
Currently this issue is on forms and reports 10g.

Previous Topic: How can we dynamically show the selected fields
Next Topic: Arabic Character report 10g send directly to printer prints junk
Goto Forum:
  


Current Time: Sat Jul 04 15:48:03 CDT 2020