| From: | marc rassbach <unixwisard(at)gmail(dot)com> |
|---|---|
| To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: failing to make LATIN1 on locale C system - what am I doing wrong? |
| Date: | 2016-06-27 08:25:03 |
| Message-ID: | CAPaK5U9cQ+bsHQdJTwkGJdiubdaL0jStwFLuRboyz0CzM2DiBw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Mon, Jun 27, 2016 at 2:46 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Max Fomichev | 2016-06-28 12:47:12 | seg fault on dsm_create call |
| Previous Message | Albe Laurenz | 2016-06-27 07:46:24 | Re: failing to make LATIN1 on locale C system - what am I doing wrong? |