Junk characters (arabic)
692290Aug 10 2010 — edited Aug 10 2010Hi everyone,
I am having hard time converting my database characters into arabic, they appearing in junk like ???? Ive got 2 tier architecture Oracle 9i R2 database and 6i forms. In the database itself the data is appearing in junk(????) where as at the client side some reports are being generated in junk(????). My concern is how do i change junk into arabic at the DB level. il post some information that may be helpfule to u all. thanks for reading.
SQL> select * from nls_database_parameters;
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LANGUAGE
AMERICAN
NLS_TERRITORY
AMERICA
NLS_CURRENCY
$
In registry i have Oracle and when i click on the + sing i have its Home...i have two NLS_LANG settings in registry....for Oracle theres nothing,the value data is NA but for HOME0 the NLS_LANG is ARABIC_UNITED ARAB EMIRATES. AR8MSWIN1256
SQL> SELECT DUMP (NAME,'1017') FROM SHR.PRV_USERS;
DUMP(NAME,'1017')
--------------------------------------------------------------------------------
Typ=1 Len=14 CharacterSet=UTF8: da,c8,cf,c7,e1,e1,e5, ,c7,e1,e4,ca,c7,dd
Typ=1 Len=12 CharacterSet=UTF8: c7,cd,e3,cf, ,c7,e1,db,c7,e3,cf,ed
Typ=1 Len=10 CharacterSet=UTF8: e3,cd,e3,cf, ,da,d3,ed,d1,ed
Typ=1 Len=12 CharacterSet=UTF8: c7,cd,e3,cf, ,c7,e1,d4,d1,c7,d1,ed
Typ=1 Len=9 CharacterSet=UTF8: cd,c7,e3,cf, ,da,c7,de,e1
Typ=1 Len=11 CharacterSet=UTF8: ce,c7,e1,cf, ,e6,de,ed,ca,c7,e4
Typ=1 Len=12 CharacterSet=UTF8: ed,c7,d3,d1, ,c7,e1,cc,c8,d1,ca,ed
Typ=1 Len=10 CharacterSet=UTF8: d3,da,cf, ,c7,e1,de,d5,ed,d1
Typ=1 Len=13 CharacterSet=UTF8: e3,e3,cf,e6,cd, ,c7,e1,e3,d1,cd,c8,ed
Typ=1 Len=11 CharacterSet=UTF8: dd,ed,d5,e1, ,c7,e1,cd,d1,c8,ed
Typ=1 Len=11 CharacterSet=UTF8: cc,c7,c8,d1, ,c7,e1,da,e3,d1,ed
SQL> SELECT sys_context('userenv','language') from dual;
SYS_CONTEXT('USERENV','LANGUAGE')
--------------------------------------------------------------------------------
ARABIC_SAUDI ARABIA.UTF8
--------------------------------------------------------------------------------
SQL> SELECT sys_context('userenv','language') from dual;
SYS_CONTEXT('USERENV','LANGUAGE')
--------------------------------------------------------------------------------
ARABIC_SAUDI ARABIA.UTF8
SQL> SELECT name,value$ from sys.props$ where na
NAME
--------------------------------------------------------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_LANGUAGE
AMERICAN
NLS_TERRITORY
AMERICA
NLS_CURRENCY
$
NAME
--------------------------------------------------------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_ISO_CURRENCY
AMERICA
NLS_NUMERIC_CHARACTERS
.,
NLS_CHARACTERSET
UTF8
NAME
--------------------------------------------------------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_CALENDAR
GREGORIAN
NLS_DATE_FORMAT
DD-MON-RR
NLS_DATE_LANGUAGE
AMERICAN
NAME
--------------------------------------------------------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_SORT
BINARY
NLS_TIME_FORMAT
HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
NAME
--------------------------------------------------------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY
$
NAME
--------------------------------------------------------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_COMP
BINARY
NLS_LENGTH_SEMANTICS
BYTE
NLS_NCHAR_CONV_EXCP
FALSE
NAME
--------------------------------------------------------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_NCHAR_CHARACTERSET
AL16UTF16
NLS_RDBMS_VERSION
9.2.0.1.0
Regards,
katheri