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
|
|
|
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?
|
|
|
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
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 #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.
|
|
|
|