Home » Non-English Forums » Arabic » when I see the Arabic characters in the server and in the form it will be showing as ?????(junk) (Server Windows 2003 and client windows XP)
when I see the Arabic characters in the server and in the form it will be showing as ?????(junk) [message #514182] Sat, 02 July 2011 05:50
jamil alshaibani
Messages: 5
Registered: January 2007
Location: saudia rabia
Junior Member

Dear Friend
I have installed Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
And when I install the database I choose character set as Arabic AR8MSWIN1256
character set AR8MSWIN1256
when I see the Arabic characters in the server and in the form it will be showing as ?????(junk)
and when I import the tables it display the following message :

import done in WE8MSWIN1256 character set and AL16UTF16 NCHAR CHARACTER SET
IMPORT SERVER USES AR8MSWIN1256 CHARACTER SET
<POSSIBLE CHARSET CONVERSION>
EXPORT CLIENT USES AR8MWIN1256 CHARACTER SET

<POSSIBLE CHARSET CONVERSION>
EXPORT SERVER USES UTF8 NCHAR CHARACTER SET
<POSSIBLE CHARSET CONVERSION>


And this is the setting in my server :

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 9.0.1.1.1

20 rows selected.


And my Forms version as the following
Forms [32 Bit] Version 6.0.8.26.0 (Production)
Oracle Toolkit Version 6.0.8.25.0 (Production)
PL/SQL Version 8.0.6.3.0 (Production)
And the NLS_LANG is set to ARABIC_ALGERIA.AR8MSWIN1256 in client PC, That is 6I FORMS

Note : when I update any junk field data to Arabic it is updating ,but how can report it because I can not update all because huge date is there so I can not update it .


Waiting for your valuable replay with examples please

Best regards

Jamil Alshaibani
Previous Topic: Re: Automatically change language from English to arabic (split from hijacked thread)
Next Topic: change language in text item
Goto Forum:
  


Current Time: Thu Mar 28 06:35:22 CDT 2024