Troubleshooting display language issues

Reports in Japanese, Korean, and Simplified Chinese languages do not appear properly

When you generate reports either in Japanese, Korean, or Simplified Chinese language, the texts in the report do not appear properly. This is due to the difference in the font definition. 

To correct this problem, update the i18n.xml and fontalias.xml files with the correct font definitions. The correct font corresponding to each language is as follows:

To update the font definitions

1. Navigate to the following location and check whether you have Arial Unicode MS" font installed:
   C:/Windows/Fonts

   If the font is not installed, download the font to the same location.

2. Open the i18n.xml file using a text editor.

   The file is located at SAPBusinessObjectsInstallationDirectory\SAP BusinessObjects Enterprise XI 4.0\win32_x86\scripts.  

3. In the file, add the following code at the end of the font_aliasing section and before the default section.

   <font
   name="Arial Unicode MS">
               <os type="all">
               <Attributs style="0"
   filename="arialuni.ttf" encoding=""aliaspsname="Arial
   Unicode MS"/>
              </os>
   </font>

4. In the file, search and identify the font definition for Tahoma.
   The script appears as follows:

   <font name="Tahoma">
   <os type="all">
   <Attributs style="0" filename="tahoma.ttf" encoding="" aliaspsname="tahoma"/>
   <Attributs style="1" filename="tahomabd.ttf" encoding="" aliaspsname="tahomabd"/> </os>> 
   </font>

5. Update the script as follows:

   *For Japanese language* 
   <font name="Tahoma"> 
   <os type="all"> 
   <Attributs style="0" filename="msgothic.ttc" encoding="CP932" aliaspsname="MS Gothic"/>
   <Attributs style="1" filename="" encoding="CP932" aliaspsname=""/> 
   <Attributs style="2" filename="" encoding="CP932" aliaspsname=""/> 
   <Attributs style="3" filename="" encoding="CP932" aliaspsname=""/> 
   </os>> 
   </font>
    
   *For Korean language*
   <font name="Tahoma">
   <os type="all"> 
   <Attributs style="0" filename="gulim.ttc" encoding="CP949" aliaspsname="Gulim"/> 
   <Attributs style="1" filename="" encoding="CP949" aliaspsname=""/>
   <Attributs style="2" filename="" encoding="CP949" aliaspsname=""/>
   <Attributs style="3" filename="" encoding="CP949" aliaspsname=""/> 
   </os>>
   </font>
   *For Simplified Chinese language*
   <font name="Tahoma">
   <os type="all">
   <Attributs style="0" filename="simsun.ttc" encoding="CP936" aliaspsname="SimSun"/> 
   <Attributs style="1" filename="" encoding="CP936" aliaspsname=""/> 
   <Attributs style="2" filename="" encoding="CP936" aliaspsname=""/>
   <Attributs style="3" filename="" encoding="CP936" aliaspsname=""/>
   </os>>
   </font>

6. Search and identify the font definition for Arial, the script appears like the following script.

   <FONT NAME="Arial">
                    <FONTFAMILY
   PLATFORM="ttf" NAME="Arial">
                    <FONTATTRIBUTE
   BOLD="false" ITALIC="false" LOGICAL="Arial"
   PHYSICAL="arial.ttf;Arial.ttf"/>
                    <FONTATTRIBUTE
   BOLD="true" ITALIC="false" LOGICAL="Arial Bold"
   PHYSICAL="arialbd.ttf;arialb.ttf;Arial-Bold.ttf"/>
                    <FONTATTRIBUTE
   BOLD="false" ITALIC="true" LOGICAL="Arial Italic"
   PHYSICAL="ariali.ttf;Arial-Italic.ttf"/>
                    <FONTATTRIBUTE
   BOLD="true" ITALIC="true" LOGICAL="Arial Bold Italic"
   PHYSICAL="arialbi.ttf;arialz.ttf;Arial-BoldItalic.ttf"/>
                    </FONTFAMILY>
                    <FONTFAMILY
   PLATFORM="win" NAME="Arial"/>
                    <FONTFAMILY
   PLATFORM="java" NAME="Arial, Helvetica, 'Courier New', 'Times
   New Roman'"/>
                    <FONTFAMILY
   PLATFORM="html" NAME="Arial, Helvetica, 'Courier New', 'Times
   New Roman'"/>
                 </FONT>

    

7. Update the script like in the following script.

   <FONT NAME="Arial">
   <FONTFAMILY PLATFORM="ttf" NAME="Arial">
                    <FONTATTRIBUTE
   BOLD="false" ITALIC="false" LOGICAL="Arial"
   PHYSICAL="ARIALUNI.TTF"/>
                    <FONTATTRIBUTE
   BOLD="true" ITALIC="false" LOGICAL="Arial Bold"
   PHYSICAL="arialbd.ttf;arialb.ttf;Arial-Bold.ttf"/>
                    <FONTATTRIBUTE
   BOLD="false" ITALIC="true" LOGICAL="Arial Italic"
   PHYSICAL="ariali.ttf;Arial-Italic.ttf"/>
                    <FONTATTRIBUTE
   BOLD="true" ITALIC="true" LOGICAL="Arial Bold
   Italic" PHYSICAL="arialbi.ttf;arialz.ttf;Arial-BoldItalic.ttf"/>
                    </FONTFAMILY>
                    <FONTFAMILY
   PLATFORM="win" NAME="Arial"/>
                    <FONTFAMILY
   PLATFORM="java" NAME="Arial, Helvetica, 'Courier New', 'Times
   New Roman', 'Arial Unicode MS'"/>
                    <FONTFAMILY
   PLATFORM="html" NAME="Arial, Helvetica, 'Courier New', 'Times
   New Roman', 'Arial Unicode MS'"/>
                    </FONT>
8. Save the file, and close it.
9. Open the fontalias.xml file using a text editor:
   The file is located at SAPBusinessObjectsInstallationDirectory\SAP BusinessObjects Enterprise XI 4.0\win32_x86\fonts and SAPBusinessObjectsInstallationDirectory\SAP BusinessObjects Enterprise XI 4.0\win64_x64\fonts.

10. In the file, add the following code for the new font before the default font section.

    <FONT
    NAME="Arial Unicode MS">
                    <FONTFAMILY
    PLATFORM="ttf" NAME="Arial Unicode MS">
                    <FONTATTRIBUTE BOLD="false"
    ITALIC="false" LOGICAL="Arial Unicode MS"
    PHYSICAL="arialuni.ttf,1"/>
                    </FONTFAMILY>
                    <FONTFAMILY
    PLATFORM="win" NAME="Arial Unicode MS"/>
                    <FONTFAMILY
    PLATFORM="java" NAME="Arial Unicode MS"/>
                    <FONTFAMILY
    PLATFORM="html" NAME="Arial Unicode MS"/>
                    </FONT>

11. In the file, search and identify the font definition for Tahoma.

    The script appears as follows:

    <FONT NAME="Tahoma">
    <FONTFAMILY PLATFORM="ttf" NAME="Tahoma"> 
    <FONTATTRIBUTE BOLD="false" ITALIC="false" LOGICAL="Times New Roman" PHYSICAL="Tahoma.ttf"/> 
    <FONTATTRIBUTE BOLD="true" ITALIC="false" LOGICAL="Times New Roman Bold" PHYSICAL="Tahomabd.ttf"/>
    </FONTFAMILY>
    <FONTFAMILY PLATFORM="win" NAME="Tahoma"/> 
    <FONTFAMILY PLATFORM="java" NAME="Tahoma, 'Times New Roman', 'Courier New'"/> 
    <FONTFAMILY PLATFORM="html" NAME="Tahoma, 'Times New Roman', 'Courier New'"/> 
    </FONT>

12. Update the script as follows:

    For Japanese language 
     
    <FONT NAME="Tahoma"> 
    <FONTFAMILY PLATFORM="ttf" NAME="MS Gothic"> 
    <FONTATTRIBUTE BOLD="false" ITALIC="false" LOGICAL="MS Gothic" PHYSICAL="msgothic.ttc,1;ARIALUNI.TTF;kochi-gothic-subst.ttf"/> 
    </FONTFAMILY> 
    <FONTFAMILY PLATFORM="win" NAME="MS Gothic"/>
    <FONTFAMILY PLATFORM="java" NAME=" 'MS Gothic', 'Arial Unicode MS'"/>
    <FONTFAMILY PLATFORM="html" NAME=" 'MS Gothic', 'Arial Unicode MS'"/> 
    </FONT> 
     
    For Korean language 
    <FONT NAME="Tahoma"> 
    <FONTFAMILY PLATFORM="ttf" NAME="Gulim">
    <FONTATTRIBUTE BOLD="false" ITALIC="false" LOGICAL="Gulim" PHYSICAL="gulim.ttc,1;ARIALUNI.TTF;kochi-gothic-subst.ttf"/> 
    </FONTFAMILY> <FONTFAMILY PLATFORM="win" NAME="Gulim"/>
    <FONTFAMILY PLATFORM="java" NAME=" 'Gulim', 'Arial Unicode MS'"/>
    <FONTFAMILY PLATFORM="html" NAME=" 'Gulim', 'Arial Unicode MS'"/>
    </FONT> 
     
    For Simplified Chinese language 
    <FONT NAME="Tahoma"> 
    <FONTFAMILY PLATFORM="ttf" NAME="SimSun"> 
    <FONTATTRIBUTE BOLD="false" ITALIC="false" LOGICAL="SimSun" PHYSICAL="simsun.ttc,0;ARIALUNI.TTF"/> 
    </FONTFAMILY> <FONTFAMILY PLATFORM="win" NAME="SimSun"/> 
    <FONTFAMILY PLATFORM="java" NAME=" SimSun, 'Arial Unicode MS'"/>
    <FONTFAMILY PLATFORM="html" NAME=" SimSun, 'Arial Unicode MS'"/> 
    </FONT>
13. Save the file, and close it.
14. Restart the SAP BusinessObjects Enterprise servers.
15. Try viewing any other Japanese, Korean, or Chinese document in Adobe Acrobat, if you don't have the correct PDF characters installed, you will be prompted to install the corresponding characters.

For Simplified Chinese language, refresh the reports to display them correctly. For Japanese and Korean, you must perform some additional settings. See Additional settings for Japanese and Korean languages. 

Additional settings for Japanese and Korean languages

You must perform these settings only for Japanese and Korean languages. The Simplified Chinese language does not require these settings.

To perform the additional settings for Japanese and Korean languages

1. Open the cs.cfg file using a text editor.
   The file is located at SAPBusinessObjectsInstallationDirectory\dataAccess\connectionServer.

2. Under the < DriverDefaults> section, add the following parameter:

   <Parameter Name="Unicode">UTF8</Parameter>
3. Save the file, and close it.
4. Open the oracle.crs file using a text editor.
   The file is located at SAPBusinessObjectsInstallationDirectory\dataAccess\connectionServer\oracle.

5. Add the following element to the list of parameters:

   JA16SJISTILDE=Shift-JIS
6. Save the file, and close it.
7. Open the oracle.sbo file using a text editor.
   The file is located at SAPBusinessObjectsInstallationDirectory\dataAccess\connectionServer.

8. Under the <Defaults>section, add the following parameter:

   <Parameter Name="Unicode">UTF8</Parameter>
9. Save the file, and close it.
10. Go to Start > Control Panel.
11. On the Control Panel window, double-click Regional and Language Options.
12. On the Regional and Language Options dialog box, on the Languages tab, under Supplemental language support, select the Install files for East Asian languages check box.
    A message describing the memory requirement is displayed.
13. Click OK, and click Apply.
14. Go to Start > Run.
15. Type regedit, and click OK.
16. On the Registry Editor window, navigate to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\<ORACLE_HOME>.
17. Update the value of NLS_LANG to AMERICAN_AMERICA.UTF8.
18. Restart the database instance and SAP BusinessObjects Enterprise servers.