Re: failing to make LATIN1 on locale C system - what am I doing wrong?
| От | marc rassbach |
|---|---|
| Тема | Re: failing to make LATIN1 on locale C system - what am I doing wrong? |
| Дата | |
| Msg-id | CAPaK5U9cQ+bsHQdJTwkGJdiubdaL0jStwFLuRboyz0CzM2DiBw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: failing to make LATIN1 on locale C system - what am I doing wrong? (Albe Laurenz <laurenz.albe@wien.gv.at>) |
| Список | pgsql-novice |
On Mon, Jun 27, 2016 at 2:46 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
template1=# CREATE DATABASE music ENCODING 'LATIN1' TEMPLATE template0 LC_COLLATE='C' LC_CTYPE='C';
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:
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 по дате отправления: