Hi all
my technical envirement:
1_ Oracle Entreprise Manager version 9.2.0.1.0
2_ Forms & Reports[32 Bit] Version 9.0.2.9.0 (Production)
3_ Oracle JInitiator: Version 1.3.1.9
4_ WebUtil Version 1.0.2(Beta)
5_ window xp service pack 3 build 2600.
6_Internet Explorer 8 Version 8.0.6001.18702
all the above softwares are running under VmWare Work Station.
I create a report red.rdf with data block based on the following query
SELECT DISTINCT
MARKAZ_ELECTOR.MARK_ELECGENDER, MARKAZ_ELECTOR.ELEC_CARDID
FROM MARKAZ_ELECTOR
In the main window of report9i builder, if I click Paper Design icon, my report displays successfully the column GENDER that contains data in Arabic font as follow:
Elec Cardid Mark Elec gender
101 ذكر
In other side if I click Run Web Layout icon of report9i builder, the internet explorer runs and display the column GENDER that must contains data in Arabic font in a wrong format as follow:
Elec Cardid Mark Elecgender
101 0C1
in addition if i write a procedure in order to save my report under pdf format; Acrobad Reader display the column GENDER that must contains data in Arabic font in a Unknown Format as follow:
Elec Cardid Mark Elecgender
101 ÇäÇË
also i would like to mention that my browser Internet Explorer display successfully data with Arabic font format when i run my forms . FMb using Form9i builder,.
How can I solve this problem of Arabic language getting from Report9i?
Thank you.
Notes: there are some steps that i execute to enable Arabic languages on Oracle9i database form9i and report9i:
1-Run Regedit i search for:
KEY_LOCAL_MACHINE---->SOFTWARE---->ORACLE ---> ALL_HOMES and i SET_LANG (ORACLE) many times by pressing CTRL+F and set it to: AMERICAN_AMERICA.AR8MSWIN1256
the same for
KEY_LOCAL_MACHINE---->SOFTWARE---->ORACLE ---> id0--> and i SET_LANG AMERICAN_AMERICA.AR8MSWIN1256
Note : initial value was AMERICAN_AMERICA.WE8MSWIN1252
2-To change the database character set, perform the following steps:
SHUTDOWN IMMEDIATE; or SHUTDOWN NORMAL.
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;
3- i execute the following command:
SELECT parameter, value
FROM v$nls_parameters
WHERE parameter = 'NLS_CHARACTERSET';
the result is
PARAMETER VALUE
----------------------------------------------------------------
NLS_CHARACTERSET AR8MSWIN1256;
4- from control panel windows xp i added input language(arabic sudia arabia)
a. Double-click Regional and Language Options.
b. i Clicked the Languages tab, and then clicked Details under "Text Services and Input Languages" which is arabic.
c. under "Installed Services", clicked the language i want to add and the keyboard layout i want to use for that language.
d. To configure the settings for the Language bar, i clicked Language Bar under "Preferences"
Thank you for your support.