PostgreSQL
Previous  Top  Next


Postgresql supports the full range of locales and charactersets. It can even use the UTF-8 (Unicode) characterset. Postgresql result databases and stakeholder databases (directory servers in the MPM) need to be created for use with the ISO-8859-1 or UTF-8 characterset.

To create a database in Postgresql that uses the ISO-8859-1 characterset type
createdb dbname -E 'LATIN1'
at the commandline, or type
create database dbname with encoding = 'LATIN1';
at the psql client, where dbname is the name of the database.

For UTF-8 encoding enter
createdb dbname -E 'UNICODE'
at the commandline, or type
create database dbname with encoding = 'UNICODE';
at the psql client, where dbname is the name of the database.

To check the encoding of the databases type psql -l at the commandline. It is also possible to configure Postgresql to use the ISO-8859-1 or UTF-8 characterset by default. Please see http://www.postgresql.org/idocs/index.php?multibyte.html for more information on the subject.