diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2022-09-16 09:37:54 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2022-09-16 09:41:33 +0200 |
| commit | c7db01e325a530ec38ec7ba57cd3ed32e123e33c (patch) | |
| tree | 699109735a34071a016940152cb6ab5e7960e74f /doc/src | |
| parent | cf2c7a736e4939ff0d6cf2acd29b17eea3bca7c2 (diff) | |
| download | postgresql-c7db01e325a530ec38ec7ba57cd3ed32e123e33c.tar.gz | |
Don't allow creation of database with ICU locale with unsupported encoding
Check in CREATE DATABASE and initdb that the selected encoding is
supported by ICU. Before, they would pass but users would later get
an error from the server when they tried to use the database.
Also document that initdb sets the encoding to UTF8 by default if the
ICU locale provider is chosen.
Author: Marina Polyakova <m.polyakova@postgrespro.ru>
Reviewed-by: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Discussion: https://www.postgresql.org/message-id/6dd6db0984d86a51b7255ba79f111971@postgrespro.ru
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/initdb.sgml | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/initdb.sgml b/doc/src/sgml/ref/initdb.sgml index f01df2dde9..8158896298 100644 --- a/doc/src/sgml/ref/initdb.sgml +++ b/doc/src/sgml/ref/initdb.sgml @@ -209,8 +209,9 @@ PostgreSQL documentation <para> Selects the encoding of the template databases. This will also be the default encoding of any database you create later, - unless you override it then. The default is derived from the locale, or - <literal>SQL_ASCII</literal> if that does not work. The character sets supported by + unless you override it then. The default is derived from the locale, + if the libc locale provider is used, or <literal>UTF8</literal> if the + ICU locale provider is used. The character sets supported by the <productname>PostgreSQL</productname> server are described in <xref linkend="multibyte-charset-supported"/>. </para> |