Installing on a non-English operating system

Applies to the following products: 
Questionmark Perception
Applies to the following Perception versions: 
Perception 5.2
Perception 5.1

When installing the English version of Perception Server on a non-English operating system, you will need to configure Perception so that it correctly stores and displays non-English characters.

To do this you will need to ensure that the:

Installing English Code Page translation table

By default, an operating system will choose the Code Page translation tables that reflect the locale chosen during system setup. When installing an English version of Perception, the operating system needs to have the Code Page translation table set to 1252 (ANSI - Latin I) as well as the Code Page for any other language types you want to use with Perception. The 1252 (ANSI - Latin I) Code Page translation table is important because the English language version of Perception uses it in the database layer. The database layer controls all the application calls to and from the database.

If the database server is a separate machine to the Perception Server it will also need to be setup with the correct Code Page Translation tables as well.

The following instructions are the same for Windows Server 2003 and Windows XP.

To find out which code page conversion tables you have installed:

    1. Select Regional and Language Options from the Control Panel
    2. Select the Advanced tab

      The code page conversion tables installed are represented in the list

      Perception requires the 1252 (ANSI - Latin I) code page to be installed as standard. Other code pages required will depend on your Server operating system language and any other character types you want to use with Perception (i.e. 1250 (ANSI - Central Europe))

      For a full list of the code page identifiers available in Windows, please refer to:

http://msdn2.microsoft.com/en-us/library/ms776446.aspx

  1. Place a checkmark in the check box of any additional code page conversion table you require
  2. Click OK to install them

Installing Language Packs on Windows Server 2008 and Vista

Language packs allow users to not only install the required scripting to use alternative alphabets but also give the user the opportunity to change the display language of the user interface, including menus and applications.

If you are using a non-English version of Windows Server 2008 or Vista to run Perception you will need to install a Language pack that contains English. This will need to be done on all the Windows Server 2008 or Vista machines used in the Perception installation.

To install a Language pack for Vista it is possible to use the Windows Update service to automatically download them. Please refer to the Microsoft instructions for further details.

Language packs for Windows Server 2008 can be downloaded from the Microsoft web site below:

To install a language pack in Windows Server 2008 complete the following steps:

  1. Click Regional and Language Options from the Control Panel
  2. Click the Keyboards and Languages tab
  3. Under Display Language, click Install/uninstall languages, and then follow the steps.

    If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

    A list of available Language packs can be found at the following website:

Database Collation

When using a SQL Server or Oracle database, it is important to set the collation of the database correctly. This is to ensure that the characters are stored appropriately for Perception to display. For details about the collation requirements for Perception Server, please refer to System Requirements.

For further details about how to setup your database, refer to:

If you have already set up your Oracle database but have set it to the incorrect Character Set, we suggest you follow the Oracle Character Set migration Best Practice. Click the link to view the guide.

www.oracle.com/technology/tech/globalization/pdf/mwp.pdf

If you have created your database but it is in the wrong superset of either AL32UTF8 or WE8MSWIN1252 you can change the character set from the command prompt using the commands below.

C:\> SQLPLUS username/password@connect_identifier (where these are the details of the database administrator)

SQL> SHUTDOWN NORMAL;

SQL> STARTUP MOUNT;

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

SQL> ALTER DATABASE OPEN;

SQL> ALTER DATABASE CHARACTER SET AL32UTF8;

SQL> SHUTDOWN NORMAL;

SQL> STARTUP;

 

Before attempting to change the Collation or Character Set of a database you should ensure that you have made a backup of the database.

Oracle also contains a secondary Character Set that refers to the locale of the database. If using AL32UTF8 this can be set to any locale required, but if usingWE8MSWIN1252 this must be set to English, United Kingdom or United States. For details about how to change the national character set, please refer to the Oracle Character set migration Best Practice above.

Further Information

For further details about Character Set migration please refer to: