Postgres Pro
Downloads
Home   >   mailing lists

Re: failing to make LATIN1 on locale C system - what am I doing wrong? - Mailing list pgsql-novice

From marc rassbach
Subject Re: failing to make LATIN1 on locale C system - what am I doing wrong?
Date
Msg-id CAPaK5U9cQ+bsHQdJTwkGJdiubdaL0jStwFLuRboyz0CzM2DiBw@mail.gmail.com
Whole thread Raw
In response to Re: failing to make LATIN1 on locale C system - what am I doing wrong?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-novice
Tree view


On Mon, Jun 27, 2016 at 2:46 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:

You should use:

CREATE DATABASE music TEMPLATE template0 LC_COLLATE="C" LC_CTYPE="C";

Yours,
Laurenz Albe

Thank you for the rabbit-trail that lead here: 
 
template1=# CREATE DATABASE music ENCODING 'LATIN1' TEMPLATE template0 LC_COLLATE='C' LC_CTYPE='C';
CREATE DATABASE
template1=# \l
                            List of databases
   Name    | Owner | Encoding | Collate |    Ctype    | Access privileges
-----------+-------+----------+---------+-------------+-------------------
 music     | pgsql | LATIN1   | C       | C           |
 postgres  | pgsql | UTF8     | C       | en_US.UTF-8 |
 template0 | pgsql | UTF8     | C       | en_US.UTF-8 | =c/pgsql         +
           |       |          |         |             | pgsql=CTc/pgsql
 template1 | pgsql | UTF8     | C       | en_US.UTF-8 | =c/pgsql         +
           |       |          |         |             | pgsql=CTc/pgsql

pgsql-novice by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: failing to make LATIN1 on locale C system - what am I doing wrong?
Next
From: Max Fomichev
Date:
Subject: seg fault on dsm_create call