Re: default locale considered harmful? (was Re: [GENERAL] Using

Поиск
Список
Период
Сортировка
От Olleg Samojlov
Тема Re: default locale considered harmful? (was Re: [GENERAL] Using
Дата
Msg-id b8b87s$18i0$1@news.hub.org
обсуждение исходный текст
Ответ на default locale considered harmful? (was Re: [GENERAL] Using index for "like 'ABC%'" type query)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> I'm beginning to think that would be a good idea, given the increasing
> prevalence of en_US as a platform locale setting.  Comments?

Americans will be agree with you. :-)

IMHO:

LC_CTYPE  -\
LC_COLLATE - Ideally make client depending for international databases. 
But it seems impossible to use indexes. May be add parameter to CREATE 
INDEX, which locale (locales) use for sorting text data?

LC_NUMERIC client depending
LC_TIME  client depending, default ISO
LC_MONETARY not usefull, lacking monetary type
LC_MESSAGES client depending for notice (client messages), server 
depending for console or syslog messages, agree with default C

Summary: Exchange information with local services (stdout, syslog, 
files, etc) must be according local locale. With client - according 
client locale.

-- 
Olleg



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Statement triggers 7.4 NEW/OLD
Следующее
От: mlw
Дата:
Сообщение: Re: close() vs. closesocket()