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, )
How can i use some fields of the form in arabic [message #567383] Sun, 30 September 2012 23:58 Go to next message
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.
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 Go to previous messageGo to next message
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 '؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟'
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 Go to previous messageGo to next message
hisham99
Messages: 66
Registered: October 2008
Location: united arab emirates
Member
change nls_lang on the registry to (Arabic_Egypt.AR8MSWIN1256)
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
hisham99
Messages: 66
Registered: October 2008
Location: united arab emirates
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
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 Go to previous messageGo to next message
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,
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 Go to previous messageGo to next message
hisham99
Messages: 66
Registered: October 2008
Location: united arab emirates
Member
when you instal the orcale database you should chose character set =AR8MSWIN1256
i thing your database character set still not change
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 Go to previous messageGo to next message
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,
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 Go to previous messageGo to next message
hisham99
Messages: 66
Registered: October 2008
Location: united arab emirates
Member
last chance try to change NLS_CHARACTERSET to AR8ISO8859P6
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 Go to previous messageGo to next message
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?
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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.
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 Go to previous message
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,

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


Current Time: Fri Dec 19 11:41:03 CST 2014

Total time taken to generate the page: 0.09694 seconds