PostgreSQL DB Encoding: SQL_ASCII vs. UTF8

[rpoehlmann]

Are there any official recommendations concerning the PostgreSQL encoding used for the Omero database? The installation manual
https://www.openmicroscopy.org/site/support/omero4/sysadmins/unix/server-installation.html
does show SQL_ASCCII in a screenshot:

Code: Select all

        List of databases
   Name         |  Owner   | Encoding
----------------+----------+-----------
omero_database | db_user  | SQL_ASCII

However, a standard PostgreSQL install uses "UTF8" encoding for a newly created DB instead.
Are there any pros/cons towards the one or other? Any (official) recommendation or experience would be appreciated.

Many thanks in advance,
-Rainer

[ajpatterson]

Rainer,

The example should be using UTF8.

I have submitted a fix to the documentation:
https://github.com/openmicroscopy/ome-d ... n/pull/171

This should appear soon in the next release of the docs.

Thanks for spotting this!

Andrew