Parallels H-Sphere Documentation System Administrator Guide

 

PostgreSQL Localization

 
 

Related Docs:   PostgreSQL Installation

Last modified: 17 Oct 2007

 

WARNING: This documentation covers Parallels H-Sphere versions up to 3.1. For the latest up-to-date Parallels H-Sphere documentation, please proceed to the official Parallels site.

To set up a custom language support (e.g. Russian) when entering data into PostrgreSQL, go through the following steps:

  1. Recompile PostgreSQL using the following keys:
    --enable-locale (enable locale support)
    --enable-recode (enable Cyrillic recode support)
    --with-mb=WIN (enable multi-byte support, e.g. WIN)
  2. Create H-Sphere database supporting the new encoding (e.g. WIN).

NOTE: if the browser encoding does not agree with the database encoding, it is impossible to guarantee a correct record in the database.

In the ~cpanel/shiva/psoft_config/hsphere.properties configuration file, replace
DB_URL = jdbc:postgresql://127.0.0.1/hsphere
with
DB_URL = jdbc:postgresql://127.0.0.1/hsphere?charSet=<YOUR_LANGUAGE_ENCODING>

For instance, Russian language support takes the following line:
DB_URL = jdbc:postgresql://127.0.0.1/hsphere?charSet=WIN


Related Docs:   PostgreSQL Installation



© Copyright 2017. Parallels Holdings. All rights reserved.