Обсуждение: Recommended cluster locale (initdb)?

Поиск
Список
Период
Сортировка

Recommended cluster locale (initdb)?

От
"Jan-Peter Seifert"
Дата:
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?

Thank you very much,

Peter







Re: Recommended cluster locale (initdb)?

От
"Gilberto Castillo"
Дата:
> 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?
>
> Thank you very much,
>
> Peter

Use UTF-8




--
Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba



Re: Recommended cluster locale (initdb)?

От
Vladimir Borodin
Дата:

23 сент. 2016 г., в 17:07, Jan-Peter Seifert <Jan-Peter.Seifert@gmx.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].



Thank you very much,

Peter







--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


--
May the force be with you…