Home » Developer & Programmer » Forms » Forms 11g, Arabic and numbers (FMW Forms 11gR2, Oracle DB 11gR2)
Forms 11g, Arabic and numbers [message #609338] Wed, 05 March 2014 16:04 Go to next message
Amine
Messages: 320
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
Re: Forms 11g, Arabic and numbers [message #609339 is a reply to message #609338] Wed, 05 March 2014 16:59 Go to previous messageGo to next message
ThomasG
Messages: 3211
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?
Re: Forms 11g, Arabic and numbers [message #609374 is a reply to message #609339] Thu, 06 March 2014 03:03 Go to previous messageGo to next message
Amine
Messages: 320
Registered: March 2010
Senior Member

Hi Thomas.

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

Say we have a table

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 Go to previous messageGo to next message
hamoudah
Messages: 1
Registered: May 2016
Junior Member
Hi Amine did you find any solution for that
Re: Forms 11g, Arabic and numbers [message #651922 is a reply to message #651256] Fri, 27 May 2016 10:51 Go to previous messageGo to next message
hisham99
Messages: 105
Registered: October 2008
Location: united arab emirates
Senior Member
add to regedit
REPORTS_ARABIC_NUMERAL context
Re: Forms 11g, Arabic and numbers [message #652527 is a reply to message #609374] Sun, 12 June 2016 02:23 Go to previous messageGo to next message
nagu_bhat
Messages: 10
Registered: May 2009
Junior Member
hi

did u get any solutions

regards
Nagaraj Bhat
Re: Forms 11g, Arabic and numbers [message #652528 is a reply to message #652527] Sun, 12 June 2016 06:36 Go to previous messageGo to next message
Amine
Messages: 320
Registered: March 2010
Senior Member

In your formsweb.cfg put
digitSubstitution=none
rather than
digitSubstitution=context
Re: Forms 11g, Arabic and numbers [message #653822 is a reply to message #652528] Tue, 19 July 2016 08:50 Go to previous messageGo to next message
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.
Re: Forms 11g, Arabic and numbers [message #653823 is a reply to message #651922] Tue, 19 July 2016 08:51 Go to previous message
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.
Previous Topic: validate data in details block before inserting into database
Next Topic: comparing comma separated values
Goto Forum:
  


Current Time: Fri Oct 30 06:35:13 CDT 2020