From: | Vladimir Borodin <root(at)simply(dot)name> |
---|---|
To: | Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)de> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Recommended cluster locale (initdb)? |
Date: | 2016-09-23 14:22:51 |
Message-ID: | AC984866-C6F0-4810-8228-200512D40F4F@simply.name |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> 23 сент. 2016 г., в 17:07, Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)de> написал(а):
>
> Hello,
>
> I wonder which locale to choose for the PostgreSQL server itself.
>
> C for performance or a UTF-8 locale for compatibility?
>
> Especially if there are LATIN1- and UTF-8 databases etc. ...
>
> I did not find any articles discussing this.
>
> Could you tell me, please?
Locale should be most certainly UTF-8. The thing to doubt is collation, you can read about it here [1].
[1] https://simply.name/pg-lc-collate.html <https://simply.name/pg-lc-collate.html>
>
> Thank you very much,
>
> Peter
>
>
>
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
--
May the force be with you…
https://simply.name
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2016-09-23 14:30:40 | Re: does cluster created through initdb update postgres-reg.ini with its entry? |
Previous Message | Jan-Peter Seifert | 2016-09-23 14:07:30 | Recommended cluster locale (initdb)? |