Re: default locale considered harmful? (was Re: [GENERAL] Using - Mailing list pgsql-hackers

From Olleg Samojlov
Subject Re: default locale considered harmful? (was Re: [GENERAL] Using
Date
Msg-id b8b87s$18i0$1@news.hub.org
Whole thread Raw
In response to default locale considered harmful? (was Re: [GENERAL] Using index for "like 'ABC%'" type query)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Andreas Pflug
Date:
Subject: Statement triggers 7.4 NEW/OLD
Next
From: mlw
Date:
Subject: Re: close() vs. closesocket()