large,
        it also forces the system to perform a checkpoint both before and
        after the creation of the new database. In some situations, this may
        have a noticeable negative impact on overall system performance. The
        <literal>FILE_COPY</literal> strategy is affected by the <xref
        linkend="guc_file_copy_method"/> setting.
       </para>
      </listitem>
     </varlistentry>
     <varlistentry id="create-database-locale">
      <term><replaceable class="parameter">locale</replaceable></term>
      <listitem>
       <para>
        Sets the default collation order and character classification in the
        new database.  Collation affects the sort order applied to strings,
        e.g., in queries with <literal>ORDER BY</literal>, as well as the order used in indexes
        on text columns.  Character classification affects the categorization
        of characters, e.g., lower, upper, and digit.  Also sets the
        associated aspects of the operating system environment,
        <literal>LC_COLLATE</literal> and <literal>LC_CTYPE</literal>.  The
        default is the same setting as the template database.  See <xref
        linkend="collation-managing-create-libc"/> and <xref
        linkend="collation-managing-create-icu"/> for details.
       </para>
       <para>
        Can be overridden by setting <xref
        linkend="create-database-lc-collate"/>, <xref
        linkend="create-database-lc-ctype"/>, <xref
        linkend="create-database-builtin-locale"/>, or <xref
        linkend="create-database-icu-locale"/> individually.
       </para>
       <para>
        If <xref linkend="create-database-locale-provider"/> is
        <literal>builtin</literal>, then <replaceable>locale</replaceable> or
        <replaceable>builtin_locale</replaceable> must be specified and set to
        either <literal>C</literal>, <literal>C.UTF-8</literal>, or
        <literal>PG_UNICODE_FAST</literal>.
       </para>
       <tip>
        <para>
         The other locale settings <xref linkend="guc-lc-messages"/>, <xref
         linkend="guc-lc-monetary"/>, <xref linkend="guc-lc-numeric"/>, and
         <xref linkend="guc-lc-time"/> are not fixed per database and are not
         set by this command.  If you want to make them the default for a
         specific database, you can use <literal>ALTER DATABASE
         ... SET</literal>.
        </para>
       </tip>
      </listitem>
     </varlistentry>
     <varlistentry id="create-database-lc-collate">
      <term><replaceable class="parameter">lc_collate</replaceable></term>
      <listitem>
       <para>
        Sets <literal>LC_COLLATE</literal> in the database server's operating
        system environment.  The default is the setting of <xref
        linkend="create-database-locale"/> if specified, otherwise the same
        setting as the template database.  See below for additional
        restrictions.
       </para>
       <para>
        If <xref linkend="create-database-locale-provider"/> is
        <literal>libc</literal>, also sets the default collation order to use
        in the new database, overriding the setting <xref
        linkend="create-database-locale"/>.
       </para>
      </listitem>
     </varlistentry>
     <varlistentry id="create-database-lc-ctype">
      <term><replaceable class="parameter">lc_ctype</replaceable></term>
      <listitem>
       <para>
        Sets <literal>LC_CTYPE</literal> in the database server's operating
        system environment.  The default is the setting of <xref
        linkend="create-database-locale"/> if specified, otherwise the same
        setting as the template database.  See below for additional
        restrictions.
       </para>
       <para>
        If <xref linkend="create-database-locale-provider"/> is
        <literal>libc</literal>, also sets the default character
        classification to use in the new database, overriding the setting
        <xref linkend="create-database-locale"/>.