This discussion is archived
9 Replies Latest reply: Sep 25, 2012 4:23 AM by Srini Chavali-Oracle RSS

i have a problem with arabic language

u0597684 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Guru Moderator
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    Justin Cave Oracle ACE
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points