Hi,
Primarily my report is in English language, but along with it, I have to put Barcode and Few Arabic Letters such as Company name in Arabic. I am Using Arial and 3of9 TTF (True Type Font). I have set the enviornment correctly, but there seems to be problem with NLS_LANG setting.
When I use AMERICAN_AMERICA.AR8ISO8859P6 my arabic characters are coming correct, but barcode fails,
if I use AMERICAN_AMERICA.WE8ISO8859P1 then Barcode is coming correct, but Arabic characters are printing junk.
I am using Unix and not Windows.
what could be the reason?
Steps I took to set environment.
1. Add following line in $ORACLE_HOME/guicommon/tk/admin/uiprint.txt
dummy:PostScript:2:dummy printer for PDF output:default.ppd:
2. in $ORACLE_HOME/guicommon/tk/admin/uifont.ali
2.1. Comment line
#Arial = helvetica
2.2. Add Following lines under
[ PDF:Subset ]
Arial..Italic.Bold.. = "arialbi.ttf"
Arial...Bold.. = "arialbd.ttf"
Arial..Italic... = "ariali.ttf"
Arial..... = "arial.ttf"
3. Add following 4 lines in $ORACLE_HOME/guicommon/tk/admin/PPD/datap462.ppd
*Font Arial: Special "(001.001)" Special ROM
*Font Ariali: Special "(001.001)" Special ROM
*Font Arialbd: Special "(001.001)" Special ROM
*Font Arialbi: Special "(001.001)" Special ROM
Comment following line like this.
*%Font Symbol: Special "(001.001)" Special ROM
4. Add following 4 lines in $ORACLE_HOME/guicommon/tk/admin/PPD/screenprinter.ppd
*Font Arial: Standard "(001.001)" Standard ROM
*Font Ariali: Standard "(001.001)" Standard ROM
*Font Arialbd: Standard "(001.001)" Standard ROM
*Font Arialbi: Standard "(001.001)" Standard ROM
5.Add/modify $ORACLE_HOME/bin/reports.sh
TK_PRINTER=dummy ; export TK_PRINTER
TK_PRINT_STATUS='echo %n is valid'; export TK_PRINT_STATUS
REPORTS_PATH=$REPORTS_PATH:$ORACLE_HOME/guicommon/tk/admin/AFM:$ORACLE_HOME/guicommon/tk/admin/PPD:$ORACLE_HOME/guicommon/tk/admin/TTF;export REPORTS_PATH
#Uncomment following line for Barcode
#NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG
#Uncomment following line For Arabic
#NLS_LANG=AMERICAN_AMERICA.AR8ISO8859P6; export NLS_LANG
6. Add following line in $ORACLE_HOME/guicommon/tk/admin/Tk2Motif.rgb like following.
!Tk2Motif*fontMapCs: iso8859-2=EE8ISO8859P2
!Tk2Motif*fontMapCs: iso8859-1=AR8ISO8859P6
7. use ttf2pt1 to generate AFM files for Arial and 3of9.ttf fonts.
8. ftp new font files to unix server
8.1 ftp afm file in ASCII format to $ORACLE_HOME/guicommon/tk/admin/AFM
8.2 ftp ttf files in BINARY format to $ORACLE_HOME/guicommon/tk/admin/TTF