To set up a custom language support (e.g. Russian) when entering
data into PostrgreSQL, go through the following steps:
- 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)
- 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
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