Home » Developer & Programmer » Reports & Discoverer » problem in arabic font in discoverer 10g (windows xp , discoverer 10.1.2.1)
problem in arabic font in discoverer 10g [message #597149] Tue, 01 October 2013 06:21 Go to next message
emadnabil
Messages: 155
Registered: August 2007
Senior Member
Dear all,

we have upgraded our discoverer from 3i to 4i and from 4i to 10g
after that we faced a strange problem related to arabic font

when openning discoverer desktop
and open the list of the saved reports
some reports that was saved by an arabic name are display by name '????'(question marks)

also another issue (but i can deal with it but i should note it as it may be helpful hint)
when openning it
it open normal but some columns that are arabic are displayed in this way (ßÇÑÊ-ÇíÌíÈÊ Êáì ßÇÑÏ- ÝÆÉ 100 Ìã)
so i must change the column font from "tahoma" to "arial" or any other font that support arabic


I have searched alot in this issue

N.B
- my NLS_lANG =american_america.ar8mswin1256
- this problem didnot happens on the discoverer 3i


Thanks


Re: problem in arabic font in discoverer 10g [message #597150 is a reply to message #597149] Tue, 01 October 2013 06:34 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2367
Registered: May 2013
Location: World Wide on the Web
Senior Member
1. What is your database character set?
select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';

2. Please execute the following and paste the output for few records-
select dump(arabic column) from table_name;



Regards,
Lalit
Re: problem in arabic font in discoverer 10g [message #597151 is a reply to message #597150] Tue, 01 October 2013 06:36 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2367
Registered: May 2013
Location: World Wide on the Web
Senior Member
Have a look at the following thread and come back - http://www.orafaq.com/forum/t/188120/

Follow Michel's suggested steps in the above link to run a test case in SQL*Plus to verify.

Regards,
Lalit

[Updated on: Tue, 01 October 2013 06:40]

Report message to a moderator

Re: problem in arabic font in discoverer 10g [message #597159 is a reply to message #597149] Tue, 01 October 2013 07:23 Go to previous messageGo to next message
emadnabil
Messages: 155
Registered: August 2007
Senior Member
Dear Mr. Lalit Kumar B
What is your database character set?
select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';


the result is :
AR8ISO8859P6



and for this

Please execute the following and paste the output for few records-
select dump(jj.name) from jtf_rs_salesreps jj ;



the result is
Typ=1 Len=10: 195,205,229,207,32,199,228,204,207,233
Typ=1 Len=10: 195,205,229,207,32,199,228,204,207,233
Typ=1 Len=10: 195,205,229,207,32,199,228,211,234,207
Typ=1 Len=10: 195,205,229,207,32,225,202,234,205,201
Typ=1 Len=10: 195,205,229,207,32,226,200,199,209,233


N.B that problem happens only in discoverer 10g and 4i
discoverer 3i , sqlplus , forms & reports works fine

Re: problem in arabic font in discoverer 10g [message #597533 is a reply to message #597159] Sat, 05 October 2013 13:29 Go to previous message
Lalit Kumar B
Messages: 2367
Registered: May 2013
Location: World Wide on the Web
Senior Member
Sorry for the late reply. Did you go through http://www.orafaq.com/forum/t/188120/

Regards,
Lalit
Previous Topic: Report Clarification
Next Topic: Reports
Goto Forum:
  


Current Time: Mon Sep 22 13:28:35 CDT 2014

Total time taken to generate the page: 0.13497 seconds