PostgreSQL DB Encoding: SQL_ASCII vs. UTF8
Posted: Mon Dec 03, 2012 10:47 am
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:
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
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