Page 1 of 1

PostgreSQL DB Encoding: SQL_ASCII vs. UTF8

PostPosted: Mon Dec 03, 2012 10:47 am
by 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

Re: PostgreSQL DB Encoding: SQL_ASCII vs. UTF8

PostPosted: Tue Dec 04, 2012 11:00 am
by 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