9 Replies Latest reply: Sep 25, 2012 6:23 AM by Srini Chavali-Oracle RSS

    i have a problem with arabic language

    u0597684
      hello all,
      im install oracle linux 5.8 and install oracle database 11g r2
      every thing is working fine
      but
      when i insert a arabic value in a field after commit the field appear like this ???????
      im using oracle sql developer to insert a new record
      thank's all :)
        • 1. Re: i have a problem with arabic language
          EdStevens
          Arafa wrote:
          hello all,
          im install oracle linux 5.8 and install oracle database 11g r2
          every thing is working fine
          but
          when i insert a arabic value in a field after commit the field appear like this ???????
          im using oracle sql developer to insert a new record
          thank's all :)
          What does this have to do with Linux?

          Better asked in the Database forum.
          • 2. Re: i have a problem with arabic language
            rukbat
            Moderator Action:
            This inquiry has been moved from the Oracle Linux forum,
            to the Database General Questions forum,
            for closer topic alignment.
            • 3. Re: i have a problem with arabic language
              Srini Chavali-Oracle
              Pl post the database characterset version - use this sql
              SQL> select * from nls_database_parameters order by 1;
              HTH
              Srini
              • 4. Re: i have a problem with arabic language
                u0597684
                PARAMETER                      VALUE
                ------------------------------ ----------------------------------------
                NLS_CALENDAR                   GREGORIAN
                NLS_CHARACTERSET               WE8MSWIN1252
                NLS_COMP                       BINARY
                NLS_CURRENCY                   $
                NLS_DATE_FORMAT                DD-MON-RR
                NLS_DATE_LANGUAGE              AMERICAN
                NLS_DUAL_CURRENCY              $
                NLS_ISO_CURRENCY               AMERICA
                NLS_LANGUAGE                   AMERICAN
                NLS_LENGTH_SEMANTICS           BYTE
                NLS_NCHAR_CHARACTERSET         AL16UTF16
                
                PARAMETER                      VALUE
                ------------------------------ ----------------------------------------
                NLS_NCHAR_CONV_EXCP            FALSE
                NLS_NUMERIC_CHARACTERS         .,
                NLS_RDBMS_VERSION              11.2.0.1.0
                NLS_SORT                       BINARY
                NLS_TERRITORY                  AMERICA
                NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
                NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
                NLS_TIME_FORMAT                HH.MI.SSXFF AM
                NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
                
                20 rows selected.
                how can i change it to arabic
                • 5. Re: i have a problem with arabic language
                  JustinCave
                  Does the database have any data in it that you need to retain? The simplest option would generally be to create a new database with the proper character set (I would suggest choosing a Unicode character set-- AL32UTF8-- though you could choose a single-byte Arabic character set like WE8ISO8859P6). If you just installed the database, simply creating a new database is likely the simplest option.

                  Justin
                  • 6. Re: i have a problem with arabic language
                    Zoltan Kecskemethy
                    WE8MSWIN1252 is a western windows character set. it does not support Arabic so you simple not able to store Arabic characters there.

                    Fully agree with Justin. Recreate your DB using AL32UTF8 as oracle recommends too.
                    Also you can migrate to UTF8 using DMU or manually ...
                    • 7. Re: i have a problem with arabic language
                      Srini Chavali-Oracle
                      If your database contains data that you cannot lose or destroy, you will need to convert the database to AL32UTF8.

                      http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch11charsetmig.htm

                      In-line conversion can be performed using DMU or csscan utilities

                      Another option is to perform an export/import as already noted

                      HTH
                      Srini
                      • 8. Re: i have a problem with arabic language
                        u0597684
                        thank's all it's working fine by this code
                        SHUTDOWN IMMEDIATE;
                        STARTUP MOUNT; 
                        ALTER SYSTEM ENABLE RESTRICTED SESSION; 
                        ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; 
                        ALTER SYSTEM SET AQ_TM_PROCESSES=0; 
                        ALTER DATABASE OPEN; 
                        ALTER DATABASE CHARACTER SET INTERNAL_USE AR8MSWIN1256;
                        SHUTDOWN IMMEDIATE;
                        STARTUP;
                        • 9. Re: i have a problem with arabic language
                          Srini Chavali-Oracle
                          Arafa wrote:
                          thank's all it's working fine by this code
                          SHUTDOWN IMMEDIATE;
                          STARTUP MOUNT; 
                          ALTER SYSTEM ENABLE RESTRICTED SESSION; 
                          ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; 
                          ALTER SYSTEM SET AQ_TM_PROCESSES=0; 
                          ALTER DATABASE OPEN; 
                          ALTER DATABASE CHARACTER SET INTERNAL_USE AR8MSWIN1256;
                          SHUTDOWN IMMEDIATE;
                          STARTUP;
                          These commands are not supported and WILL cause your database to be corrupted beyond repair - I hope you have a good backup of this database - readers of this thread should NOT attempt to use these commands to change the characterset of any database.

                          Getting ORA-01429 error while changing character set
                          Re: change NATIONAL CHARACTER SET

                          HTH
                          Srini