@@ -150,12 +150,12 @@ CREATE DATABASE <replaceable class="parameter">name</replaceable>
150
150
<para>
151
151
Sets the default collation order and character classification in the
152
152
new database. Collation affects the sort order applied to strings,
153
- e.g., in queries with <literal>ORDER BY</literal>, as well as the order used in indexes
154
- on text columns. Character classification affects the categorization
155
- of characters, e.g., lower, upper, and digit. Also sets the
156
- associated aspects of the operating system environment,
157
- <literal>LC_COLLATE</literal> and <literal>LC_CTYPE</literal> . The
158
- default is the same setting as the template database. See <xref
153
+ e.g., in queries with <literal>ORDER BY</literal>, as well as the
154
+ order used in indexes on text columns. Character classification
155
+ affects the categorization of characters, e.g., lower, upper, and
156
+ digit. Also sets the <literal>LC_CTYPE</literal> aspect of the
157
+ operating system environment . The default is the same setting as the
158
+ template database. See <xref
159
159
linkend="collation-managing-create-libc"/> and <xref
160
160
linkend="collation-managing-create-icu"/> for details.
161
161
</para>
@@ -189,17 +189,16 @@ CREATE DATABASE <replaceable class="parameter">name</replaceable>
189
189
<term><replaceable class="parameter">lc_collate</replaceable></term>
190
190
<listitem>
191
191
<para>
192
- Sets <literal>LC_COLLATE</literal> in the database server's operating
193
- system environment. The default is the setting of <xref
194
- linkend="create-database-locale"/> if specified, otherwise the same
195
- setting as the template database. See below for additional
196
- restrictions .
192
+ If <xref linkend="create-database-locale-provider"/> is
193
+ <literal>libc</literal>, sets the default collation order to use in
194
+ the new database, overriding the setting <xref
195
+ linkend="create- database-locale"/>. Otherwise, this setting is
196
+ ignored .
197
197
</para>
198
198
<para>
199
- If <xref linkend="create-database-locale-provider"/> is
200
- <literal>libc</literal>, also sets the default collation order to use
201
- in the new database, overriding the setting <xref
202
- linkend="create-database-locale"/>.
199
+ The default is the setting of <xref linkend="create-database-locale"/>
200
+ if specified, otherwise the same setting as the template database.
201
+ See below for additional restrictions.
203
202
</para>
204
203
</listitem>
205
204
</varlistentry>
@@ -208,16 +207,18 @@ CREATE DATABASE <replaceable class="parameter">name</replaceable>
208
207
<listitem>
209
208
<para>
210
209
Sets <literal>LC_CTYPE</literal> in the database server's operating
211
- system environment. The default is the setting of <xref
212
- linkend="create-database-locale"/> if specified, otherwise the same
213
- setting as the template database. See below for additional
214
- restrictions.
210
+ system environment.
215
211
</para>
216
212
<para>
217
213
If <xref linkend="create-database-locale-provider"/> is
218
- <literal>libc</literal>, also sets the default character
219
- classification to use in the new database, overriding the setting
220
- <xref linkend="create-database-locale"/>.
214
+ <literal>libc</literal>, sets the default character classification to
215
+ use in the new database, overriding the setting <xref
216
+ linkend="create-database-locale"/>.
217
+ </para>
218
+ <para>
219
+ The default is the setting of <xref linkend="create-database-locale"/>
220
+ if specified, otherwise the same setting as the template database.
221
+ See below for additional restrictions.
221
222
</para>
222
223
</listitem>
223
224
</varlistentry>
0 commit comments