OraFAQ Forum: Forms » Forms 11g, Arabic and numbers

Home » Developer & Programmer » Forms » Forms 11g, Arabic and numbers (FMW Forms 11gR2, Oracle DB 11gR2)

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

Forms 11g, Arabic and numbers [message #609338]

Wed, 05 March 2014 16:04

Amine
Messages: 376
Registered: March 2010

Senior Member

Hi all,
We are using Oracle Forms 11gR2 with Oracle 11gR2 DB. The DB character set is UTF8 and we store Arabic data in some tables. In a table called address, we store customers addresses in Arabic.
Say we have this data : 13 شارع السلام.

In a text field in a form, this data is displayed like this : ١٣ شارع السلام (with Eastern Arabic numerals).
What we have to do to keep the numbers in eastern Arabic numeral ?

Thanks in advance,

Amine

Report message to a moderator

Re: Forms 11g, Arabic and numbers [message #609339 is a reply to message #609338]

Wed, 05 March 2014 16:59

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Is "13 شارع السلام." stored as a varchar2 in a single column?

Or is "شارع السلام." stored in a varchar2 column, and 13 in a number column that perhaps gets formatted for display in the text field?

Report message to a moderator

Re: Forms 11g, Arabic and numbers [message #609374 is a reply to message #609339]

Thu, 06 March 2014 03:03

Amine
Messages: 376
Registered: March 2010

Senior Member

Hi Thomas.

All the data is stored in a single column as a varchar2.

Say we have a table

Code: [Select all] [Show/ hide]

create table test
(
      my_address    varchar2(100)
)
/

insert into test values ('13 شارع السلام');

This problem occurs only in Forms. Numbers in Reports are displayed as we want that is in western arabic numeral (1,2,3...)

[Updated on: Thu, 06 March 2014 03:05]

Report message to a moderator

Re: Forms 11g, Arabic and numbers [message #651256 is a reply to message #609374]

Fri, 13 May 2016 11:20

hamoudah
Messages: 1
Registered: May 2016

Junior Member

Hi Amine did you find any solution for that

Report message to a moderator

Re: Forms 11g, Arabic and numbers [message #651922 is a reply to message #651256]

Fri, 27 May 2016 10:51

hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates

Senior Member

add to regedit
REPORTS_ARABIC_NUMERAL context

Report message to a moderator

Re: Forms 11g, Arabic and numbers [message #652527 is a reply to message #609374]

Sun, 12 June 2016 02:23

nagu_bhat
Messages: 10
Registered: May 2009

Junior Member

hi

did u get any solutions

regards
Nagaraj Bhat

Report message to a moderator

Re: Forms 11g, Arabic and numbers [message #652528 is a reply to message #652527]

Sun, 12 June 2016 06:36

Amine
Messages: 376
Registered: March 2010

Senior Member

In your formsweb.cfg put
digitSubstitution=none
rather than
digitSubstitution=context

Report message to a moderator

Re: Forms 11g, Arabic and numbers [message #653822 is a reply to message #652528]

Tue, 19 July 2016 08:50

linlasj
Messages: 98
Registered: August 2005
Location: LinkÃ¶ping

Member

I would seperate the adress and the number, so that the number will be 123... and the name of the street in arabic lettering. Then have a concatenated field when showing the data.

Report message to a moderator

Re: Forms 11g, Arabic and numbers [message #653823 is a reply to message #651922]

Tue, 19 July 2016 08:51

linlasj
Messages: 98
Registered: August 2005
Location: LinkÃ¶ping

Member

Well. That should be done - if this works - in some other way than in regedit.

Report message to a moderator

Previous Topic:	validate data in details block before inserting into database
Next Topic:	comparing comma separated values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 08:22:27 CDT 2025