OraFAQ Forum: Forms » How can i use some fields of the form in arabic

Home » Developer & Programmer » Forms » How can i use some fields of the form in arabic (CLIENT: Oracle Developer 6i with windows 7, SERVER Database 10g with Windows Srvr 2003, )

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

How can i use some fields of the form in arabic [message #567383]

Sun, 30 September 2012 23:58

adeel_ans786
Messages: 22
Registered: September 2012
Location: United Arab Emirates

Junior Member

Hi,

i want to use arabic language in one of the fields available on the form. is it possible? if yes they how?

i alreade have done the following

1. On database

update PROPS$
set value$ ='AR8MSWIN1256'
where name = 'NLS_CHARACTERSET';

2. On system registry

Have changed all nls_lang variable in the registry to 'American_America.AR8MSWIN1256'

3. On Form

Have changed the field font to 'Simplified Arabic' and reading order 'right to left'

4. On Operating System
Change the region and language setting
format 'Arabic (saudi Arabia)'
keyboard and languages add 'Arabic (saudi arabia)'

5. have restarted the database on the server and also the client machine.

Report message to a moderator

Re: How can i use some fields of the form in arabic [message #567385 is a reply to message #567383]

Mon, 01 October 2012 00:35

adeel_ans786
Messages: 22
Registered: September 2012
Location: United Arab Emirates

Junior Member

i would like to add the following

1. filed type in the database is varchar2.
2. I'm able to right arabic in the text field but when i'm fetching the data on form it appears like '???????????????????????????' and in the database also it is stored like '؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟'

Report message to a moderator

Re: How can i use some fields of the form in arabic [message #567412 is a reply to message #567385]

Mon, 01 October 2012 02:51

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

Senior Member

change nls_lang on the registry to (Arabic_Egypt.AR8MSWIN1256)

Report message to a moderator

Re: How can i use some fields of the form in arabic [message #567415 is a reply to message #567412]

Mon, 01 October 2012 03:01

adeel_ans786
Messages: 22
Registered: September 2012
Location: United Arab Emirates

Junior Member

Thank you very much for your reply.

I change all registery for NLS_LANG to 'Arabic_Egypt.AR8MSWIN1256' on the client side only and then i open the form and make a new entry. the result is still the same...i'm still able to type in arabic but when i query the data it appears like before '???????????????????'.

Waiting for your reply

Regards,

[Updated on: Mon, 01 October 2012 03:03]

Report message to a moderator

Re: How can i use some fields of the form in arabic [message #567416 is a reply to message #567415]

Mon, 01 October 2012 03:09

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

Senior Member

on control panel
open regional tab and change
location to saudi arabia, and formate to saudi arabia
2)for language tab ,change supplement language support chose script left_to right
3)on advance tab chose any thing relative to arabic

Report message to a moderator

Re: How can i use some fields of the form in arabic [message #567420 is a reply to message #567416]

Mon, 01 October 2012 03:25

adeel_ans786
Messages: 22
Registered: September 2012
Location: United Arab Emirates

Junior Member

on a client machine (windows 7)
on region and language window
format is set on 'arabic (saudi arabia)'
Location is set to 'Saudi Arabia'
In input languages i have added 'arabic (Egypt)' and 'Arabic (Saudi Arabia)'

after the above setting i re run the form but still having same result '??????'

waiting for your reply

Regards,

Report message to a moderator

Re: How can i use some fields of the form in arabic [message #567422 is a reply to message #567420]

Mon, 01 October 2012 03:53

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

Senior Member

when you instal the orcale database you should chose character set =AR8MSWIN1256
i thing your database character set still not change

Report message to a moderator

Re: How can i use some fields of the form in arabic [message #567425 is a reply to message #567422]

Mon, 01 October 2012 04:09

adeel_ans786
Messages: 22
Registered: September 2012
Location: United Arab Emirates

Junior Member

i run the following query by sys login in the database

select *
from nls_database_parameters
where parameter like '%NLS%';

and i got following results:-

PARAMETER VALUE
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AR8MSWIN1256
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.1.0

Please advice

Waiting for your response

Regards,

Report message to a moderator

Re: How can i use some fields of the form in arabic [message #567432 is a reply to message #567425]

Mon, 01 October 2012 05:28

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

Senior Member

last chance try to change NLS_CHARACTERSET to AR8ISO8859P6

Report message to a moderator

Re: How can i use some fields of the form in arabic [message #567438 is a reply to message #567432]

Mon, 01 October 2012 05:49

adeel_ans786
Messages: 22
Registered: September 2012
Location: United Arab Emirates

Junior Member

i've done this change but no luck.....still same problem

any adivce?

Report message to a moderator

Re: How can i use some fields of the form in arabic [message #567485 is a reply to message #567438]

Tue, 02 October 2012 02:08

uzairawan
Messages: 4
Registered: October 2012
Location: Pakistan

Junior Member

I think you should dicuss your problem on Oracle Forums. May be you can find any solution there, except the mentioned above.

Report message to a moderator

Re: How can i use some fields of the form in arabic [message #567508 is a reply to message #567485]

Tue, 02 October 2012 22:44

adeel_ans786
Messages: 22
Registered: September 2012
Location: United Arab Emirates

Junior Member

Yes you are right...thank you very much for your time and help.

Report message to a moderator

Re: How can i use some fields of the form in arabic [message #583783 is a reply to message #567508]

Fri, 03 May 2013 16:30

MohMus
Messages: 1
Registered: May 2013

Junior Member

Hi
You have to match the full nls parameter (not only the last part ) between the database and windows registry.
in your case its AMERICAN_AMERICA.AR8MSWIN1256
--
Try it.

Report message to a moderator

Re: How can i use some fields of the form in arabic [message #583848 is a reply to message #583783]

Sun, 05 May 2013 23:00

adeel_ans786
Messages: 22
Registered: September 2012
Location: United Arab Emirates

Junior Member

Thank you very much MohMus for your information, i solved this problem by re installing the database with AR8MSWIN1256 CHARACTERSET.

Regards,

Report message to a moderator

Previous Topic:	Single Record Works. All Not Workss.
Next Topic:	.fmx files into seperate folder

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 11:49:34 CDT 2024