Home » Developer & Programmer » Forms » How to use unicode in Developer
How to use unicode in Developer [message #130436] Sat, 30 July 2005 06:52 Go to next message
saqib81
Messages: 11
Registered: July 2005
Junior Member
Hi all,
can any one plz tell me how can i use uni code in Oracle and in oracle forms.
thanx
Re: How to use unicode in Developer [message #131011 is a reply to message #130436] Wed, 03 August 2005 18:45 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What do you mean by 'uni code'? Please give a little more detail.

It sounds like you may need to change the NLS_LANG and NLS_LANGUAGE settings in your enviuronments.

David
Re: How to use unicode in Developer [message #131087 is a reply to message #130436] Thu, 04 August 2005 05:32 Go to previous messageGo to next message
saqib81
Messages: 11
Registered: July 2005
Junior Member
i want to use Arabic characters in Oracle Developer forms and also want to save it can u plz help me
Re: How to use unicode in Developer [message #131206 is a reply to message #131087] Thu, 04 August 2005 18:28 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'NLS', 'NLS_LANG', and 'NLS_LANGUAGE'. But this example is probably enough http://www.orafaq.com/forum/m/125221/67467/?srch=nls_lang#msg_125221.

David
Re: How to use unicode in Developer [message #131301 is a reply to message #130436] Fri, 05 August 2005 04:00 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

Hi,
set NLS_LANGUAGE parameter in the registry for forms to AMERICAN_AMERICA.AR8MSWIN1256.
Re: How to use unicode in Developer [message #131333 is a reply to message #131206] Fri, 05 August 2005 07:15 Go to previous messageGo to next message
saqib81
Messages: 11
Registered: July 2005
Junior Member
i want to use 2 languages that is English and Arabic how can i use both of them simultaneously
Thanks
Saqib
Re: How to use unicode in Developer [message #131431 is a reply to message #131333] Sat, 06 August 2005 04:01 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

The fields in which you want to write only arabic, change the properties of those fields :
Font Name : Arabic Transparent
Initial Keyboard State : Local
Reading Order : Right to Left
Keyboard State : Local Only

Set these properties of the field where you want to type only arabic. You can type english in other fields.
If this is what you'r intended to do then cheers, if not then describe briefly what else you want to do.

Regards.
Re: How to use unicode in Developer [message #131440 is a reply to message #131431] Sat, 06 August 2005 05:56 Go to previous messageGo to next message
saqib81
Messages: 11
Registered: July 2005
Junior Member
i have version of Developer is 2000 and there is no such font available and if there is font available then how can i save data into table bcoz oracle is not supporting arabic font
Re: How to use unicode in Developer [message #131444 is a reply to message #131440] Sat, 06 August 2005 06:28 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

hmmm.....I'm using Oracle 9i Database and forms 6i.
which version of database and forms you'r using?
Secondly, have you made your windows Arabic Enabled?
i.e: When you press Alt + Shift from your keyboard, can you write arabic in notepad?
If no then make your window Arabic enabled first.
And in forms you don't need to change the font name, just change the properties of the field under the heading International.
There you can find these properties to set the field's language Local and reading order from right to left etc...
  • Attachment: untitled.GIF
    (Size: 148.22KB, Downloaded 695 times)
Re: How to use unicode in Developer [message #131450 is a reply to message #131444] Sat, 06 August 2005 08:29 Go to previous messageGo to next message
saqib81
Messages: 11
Registered: July 2005
Junior Member
i am using Database 9i and Developer 2000
and secondly how can i make my windows arabic enabled
and i cant able to c ur attachment
Re: How to use unicode in Developer [message #131451 is a reply to message #130436] Sat, 06 August 2005 08:53 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

To open the file and see what it in it. Click on the image, when it opens then save it in your computer as .bmp image. Then open it. If not clear then open this image in the window's paint brush. Everything will be clear.
I downloaded the image and it is clear.
You may need the windows 2000 operating system CD to make your window arabic enabled.
Go to control panel and the then Regional and Languages option. You can make your window arabic enabled from there. Find teh attached file as well and check it.

Regards.
  • Attachment: lang.GIF
    (Size: 103.66KB, Downloaded 586 times)

[Updated on: Sat, 06 August 2005 08:55]

Report message to a moderator

Re: How to use unicode in Developer [message #131541 is a reply to message #131451] Mon, 08 August 2005 03:12 Go to previous messageGo to next message
saqib81
Messages: 11
Registered: July 2005
Junior Member
i checked the attached file and make my windows arabic enabled now the problem is how can i check my windows is accepting arabic i mean by typing in arabic or something else. ??????
Theo other prob. is the given picture is of windows XP i guess and i have windows 2000 professional edition. so it is different in setting regional setting in it but still i manage to get change regional setting but now how can i check the regional setting is set perfectly. plz help me ? thanx
Re: How to use unicode in Developer [message #131610 is a reply to message #131541] Mon, 08 August 2005 10:34 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

Open NOTEPAD.
Write something. You'll see english alphabets there. Now press Alt+Shift from the keyboard and write something again on the notepad.
Now you should see arabic alphabets if you have made your window arabic enabled.

Regards.
Re: How to use unicode in Developer [message #131723 is a reply to message #131610] Tue, 09 August 2005 03:22 Go to previous messageGo to next message
saqib81
Messages: 11
Registered: July 2005
Junior Member
Hey Good news i m getting Arabic typing in Notepad Smile
Now what will be the next step to make use of uni code in Developer 2000 . Remember i m using Developer 2000 not developer 6i and database is 9i.
Thank you once again.
Re: How to use unicode in Developer [message #131820 is a reply to message #131723] Tue, 09 August 2005 10:48 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

First of all Open SQL*Plus.
do something there like this:
SQL> conn scott/tiger
Connected.
SQL> CREATE TABLE testme
  2  (ar VARCHAR2(32));

Table created.

SQL> INSERT INTO testme
  2  VALUES('ÇäÊ');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM testme;

AR
--------------------------------
ÇäÊ

SQL> DROP TABLE testme;

Table dropped.
I wrote arabic but this forum is not arabic enabled so it's not showing here. If you can write arabic here and then retrieve it you'r almost done.
If you see ?????? in your query result, then let me know.


Check this and then tell me if you can store arabic characters in your database or not.

Regards.
Re: How to use unicode in Developer [message #131916 is a reply to message #131820] Wed, 10 August 2005 01:31 Go to previous messageGo to next message
saqib81
Messages: 11
Registered: July 2005
Junior Member
I have created table n store multilanguage value and the retrieve it i got the result right.
now what will be the next step
Re: How to use unicode in Developer [message #132061 is a reply to message #131916] Wed, 10 August 2005 11:26 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

Open Form Builder, Create a test form. Open the Canvas.
Select the text Tool and write something in Arabic. See if you can write arabic there as well or not. If not then See my first two posts and files attaached and make changes in the NLS_LANG parameter in the registry. To write and retrieve arabic in the form items you need to change some properties of the items.
Check my files again to know which item's property you have to change.

Regards.
Re: How to use unicode in Developer [message #132150 is a reply to message #132061] Thu, 11 August 2005 01:44 Go to previous messageGo to next message
saqib81
Messages: 11
Registered: July 2005
Junior Member
i have done it man done it
Yo man Yo
Thanks
Saqib
Now letme know buddy how can i store image in oracle
and lemme know from which country u r
Thank you
Thanx once again for ur cooperation
Wish u all the best
Saqib
Re: How to use unicode in Developer [message #132241 is a reply to message #132150] Thu, 11 August 2005 09:06 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

Thanks for your appreciation. Sounds nice. I'm from Pakistan but I'm working in Kuwait. To store images in database, search this forum and you'll find lots of posts because this question is asked almost every week here on this forum.
If you don't get the answer then reply me, I'll let you know how to do this.

Cheers.
Re: How to use unicode in Developer [message #132660 is a reply to message #132241] Mon, 15 August 2005 09:48 Go to previous messageGo to next message
saqib81
Messages: 11
Registered: July 2005
Junior Member
Asalam u Alaikum Wr Wb

SadaatAhmed How r u ? hope u r fine (Ameen) yaar do u know
what is replication in oracle if yes then lemme know
thanks
Re: How to use unicode in Developer [message #282741 is a reply to message #131820] Fri, 23 November 2007 04:39 Go to previous message
Sporadic
Messages: 14
Registered: January 2007
Location: Faisalabad
Junior Member

saadatahmad wrote on Tue, 09 August 2005 20:48

First of all Open SQL*Plus.
do something there like this:
SQL> conn scott/tiger
Connected.
SQL> CREATE TABLE testme
  2  (ar VARCHAR2(32));

Table created.

SQL> INSERT INTO testme
  2  VALUES('ÇäÊ');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM testme;

AR
--------------------------------
ÇäÊ

SQL> DROP TABLE testme;

Table dropped.
I wrote arabic but this forum is not arabic enabled so it's not showing here. If you can write arabic here and then retrieve it you'r almost done.
If you see ?????? in your query result, then let me know.


Check this and then tell me if you can store arabic characters in your database or not.

Regards.

Saadat bhai, I have done all the above step,

I can save data in Oracle 8i through SQL PLUS in URDU/ARABIC, I can write data in Developer as well in Urdu/Arabic, but when I save it through form it saves ?????????? in DATABASE(backend) and also when i tried to retrieve data through forms or report it displayed ???????? and some time inverted ????????.

Please help me out, what should I do, My forms and database character set is AMERICAN_AMERICA.AR8MSWIN1256.

Please help

Regards
Faisal

[Updated on: Fri, 23 November 2007 04:43]

Report message to a moderator

Previous Topic: i am getting error in forms 6i "Foreign key value does not currently exist in primary key table
Next Topic: Form in browser probelm !
Goto Forum:
  


Current Time: Fri Dec 02 14:21:29 CST 2016

Total time taken to generate the page: 0.09825 seconds