1 2 Previous Next 18 Replies Latest reply: Jun 11, 2010 11:00 AM by AmmadAhmed RSS

    how to display arabic in forms

    697151
      hi friends

      I use Oracled database 10g in windows xp sp2

      previously I was just change the value NLS_LANG for the following keys :
      HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_DevSuiteHome1
      HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1
      from
      AMERICAN_AMERICA.WE8MSWIN1252
      to
      ARABIC_SAUDI ARABIA.AR8MSWIN1256
      and i also change in ( Control Panel > Regional and Language Option ) this tabs ( Regional Option & Advanced) to Arabic Saudi Arabia

      then I could insert value and I also could query to display this data from both SQL*PLUS.exe and Forms

      but now I couldn't pleeeeeeeez someone tell me what i miss

      any help and advice I greatly appreciated

      thanks

      Edited by: user10947262 on Jun 10, 2010 6:00 PM
        • 1. Re: how to display arabic in forms
          CraigB
          Looking at the Oracle Support document 1015554.4 (How to Configure Forms for Use with Arabic Characters) it appears you have covered all of the NLS_LANG settings. The only you don't mention is the RDBMS Character set (NLS_CHARACTERSET). Have you checked the NLS_CHARACTERSET?

          Craig...
          • 2. Re: how to display arabic in forms
            697151
            hi CraigB

            thanks for reply this is my NLS_CHARACTERSET before updating
            SQL> select * from  nls_database_parameters;
             
            PARAMETER                      VALUE
            ------------------------------ --------------------------------------
            NLS_LANGUAGE                   AMERICAN
            NLS_TERRITORY                  AMERICA
            NLS_CURRENCY                   $
            NLS_ISO_CURRENCY               AMERICA
            NLS_NUMERIC_CHARACTERS         .,
            NLS_CHARACTERSET               WE8MSWIN1252      <==========
            NLS_CALENDAR                   GREGORIAN
            NLS_DATE_FORMAT                DD-MON-RR
            NLS_DATE_LANGUAGE              AMERICAN
            NLS_SORT                       BINARY
            NLS_TIME_FORMAT                HH.MI.SSXFF AM
             
            PARAMETER                      VALUE
            ------------------------------ --------------------------------------
            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
             
            20 rows selected.
             
            SQL>
            and this is nls_charachterset after update
            SQL> select * from  nls_database_parameters;
             
            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
             
            PARAMETER                      VALUE
            ------------------------------ ----------------------------------------
            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
             
            20 rows selected.
             
            SQL>
            plz man i still stucked could you guide me what's next

            thanks for reply again

            Craig could you tell me where i can find this document you mention (1015554.4 (How to Configure Forms for Use with Arabic Characters) )

            Edited by: user10947262 on Jun 11, 2010 11:11 AM
            • 3. Re: how to display arabic in forms
              Sarah
              hi

              try to set UTF-8 then it will be work.

              sarah
              • 4. Re: how to display arabic in forms
                Zeeshan BaiG
                what is appearing on your form?

                please show us a screen shot

                usually it requires

                1) your database characterset must be Arabic or UTF8
                2) set your enviornment variable NLS_LANG to
                3) set control panel regional settings with arabic encoding
                4) add arabic keyboard to your OS
                5) set the Fonts on TEXT ITEM with Arabic Script

                Hope it helps
                • 5. Re: how to display arabic in forms
                  Sarah
                  hi

                  check out the following link.

                  http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm


                  sarah
                  • 6. Re: how to display arabic in forms
                    697151
                    heloo Biag

                    thanks for reply this is my screen shot
                    what is appearing on your form?
                    http://i49.tinypic.com/2eltjs6.jpg
                    1) your database characterset must be Arabic or UTF8
                    http://i50.tinypic.com/2vafgjt.jpg
                    http://i45.tinypic.com/2igoqva.jpg
                    2) set your enviornment variable NLS_LANG to
                    http://i47.tinypic.com/xd9p9f.jpg
                    3) set control panel regional settings with arabic encoding
                    http://i50.tinypic.com/2ewzgbd.jpg
                    http://i49.tinypic.com/15yhr3s.jpg
                    4) add arabic keyboard to your OS
                    http://i47.tinypic.com/242sd5e.jpg
                    5) set the Fonts on TEXT ITEM with Arabic Script
                    http://i48.tinypic.com/2u4lppw.jpg

                    thanks again Baig amd I hope I make it will to help me
                    • 7. Re: how to display arabic in forms
                      697151
                      try to set UTF-8 then it will be work.
                      hi sara could you guide me how i can modify

                      thanks
                      • 8. Re: how to display arabic in forms
                        Zeeshan BaiG
                        Thanks for screen shots all seems ok

                        Try to change the NLS_LANG settings in Registry to "AMERICAN_AMERICA.UTF8"

                        and change the font to ARIAL with Script arabic
                        • 9. Re: how to display arabic in forms
                          697151
                          hi Baig I changed the NLS_LANG settings in Registry to "AMERICAN_AMERICA.UTF8" as you mentioned

                          http://i47.tinypic.com/jpx451.jpg



                          and I also changed the font to ARIAL with Script arabic as you mentioned

                          http://i49.tinypic.com/2crax4w.jpg


                          but still no luck plz more help


                          see http://i46.tinypic.com/zx028l.jpg
                          • 10. Re: how to display arabic in forms
                            AmmadAhmed
                            Hello,
                            Use the one in you NLS_LANG setting of developer in registry. As you were using before.
                            AMERICAN_AMERICA.AR8MSWIN1256
                            And after this remove the old data from table and enter the new arabic data and then try to retrieve.
                            Then tell us what is the output.

                            -Ammad
                            • 11. Re: how to display arabic in forms
                              697151
                              hi Ammad thanks for interesting
                              Use the one in you NLS_LANG setting of developer in registry. As you were using before.
                              AMERICAN_AMERICA.AR8MSWIN1256
                              check this 2 links plz I changed to AMERICAN_AMERICA.AR8MSWIN1256 in both the developer key and oracle database key

                              for developer key http://i48.tinypic.com/15psrvt.jpg
                              for oracle database key http://i49.tinypic.com/flv6vl.jpg
                              And after this remove the old data from table and enter the new arabic data and then try to retrieve.
                              http://i48.tinypic.com/16jr2hg.jpg
                              Then tell us what is the output.
                              unfortunately http://i46.tinypic.com/335b6n8.jpg

                              sorry man
                              • 12. Re: how to display arabic in forms
                                AmmadAhmed
                                First thing is why are u inserting records from sql plus?
                                And also the data you are inserting through sql plus is not Arabic Fonts.

                                1. Insert data using form in arabic language. (You can insert arabic by shifting language from keyboard Right Alt+Shift) Also check that using forms you can insert data in arabic or not? If yes then its ok.
                                2. Search in registry there are three NLS_LANG use the same code in three of them.
                                3. After inserting arabic data. Close the form and open again and then try to retrieve.

                                -Ammad
                                • 13. Re: how to display arabic in forms
                                  697151
                                  I forget to say something in the beginning of this procedure this is my NLS_CHARACTERSET it was WE8MSWIN1252
                                  SQL> select *
                                    2  from nls_database_parameters
                                    3  where parameter='NLS_CHARACTERSET';
                                  
                                  PARAMETER                      VALUE
                                  ------------------------------ -------------
                                  NLS_CHARACTERSET               WE8MSWIN1252
                                  but I change it to AR8MSWIN1256 by this update statement
                                  update PROPS$ 
                                  set value#='AR8MSWIN1256' 
                                  where name = 'NLS_CHARACTERSET';
                                  after this update statement when i issue this select statement this the result
                                  SQL> select *
                                    2  from nls_database_parameters
                                    3  where parameter='NLS_CHARACTERSET';
                                  
                                  PARAMETER                      VALUE
                                  ------------------------------ -------------
                                  NLS_CHARACTERSET               AR8MSWIN1256
                                  my question is this update is right or wrong ?

                                  I'm sooo sorry friends i forget this
                                  • 14. Re: how to display arabic in forms
                                    697151
                                    1. Insert data using form in arabic language. (You can insert arabic by shifting language from keyboard Right Alt+Shift) Also check that using forms you can insert data in arabic or not? If yes then its ok.
                                    it's work it's work ......wooooooooooow crazy guy
                                    1 2 Previous Next