OraFAQ Forum: Reports & Discoverer » problem in arabic font in discoverer 10g

Home » Developer & Programmer » Reports & Discoverer » problem in arabic font in discoverer 10g (windows xp , discoverer 10.1.2.1)

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

problem in arabic font in discoverer 10g [message #597149]

Tue, 01 October 2013 06:21

emadnabil
Messages: 179
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

Report message to a moderator

Re: problem in arabic font in discoverer 10g [message #597150 is a reply to message #597149]

Tue, 01 October 2013 06:34

Lalit Kumar B
Messages: 3174
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

Report message to a moderator

Re: problem in arabic font in discoverer 10g [message #597151 is a reply to message #597150]

Tue, 01 October 2013 06:36

Lalit Kumar B
Messages: 3174
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

emadnabil
Messages: 179
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

Report message to a moderator

Re: problem in arabic font in discoverer 10g [message #597533 is a reply to message #597159]

Sat, 05 October 2013 13:29

Lalit Kumar B
Messages: 3174
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

Report message to a moderator

Previous Topic:	Report Clarification
Next Topic:	Reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 00:44:56 CST 2024