Re: Per-column collation
Marcin Mańk <marcin.mank@gmail.com>
From: marcin mank <marcin.mank@gmail.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Pavel Stehule <pavel.stehule@gmail.com>, pgsql-hackers@postgresql.org
Date: 2010-11-16T20:05:16Z
Lists: pgsql-hackers
> I can only look at the locales that the operating system provides. We > could conceivably make some simplifications like stripping off the > ".utf8", but then how far do we go and where do we stop? Locale names > on Windows look different too. But in general, how do you suppose we > should map an operating system locale name to an "acceptable" SQL > identifier? You might hope, for example, that we could look through the It would be nice if we could have some mapping of locale names bult in, so one doesn`t have to write alternative sql depending on DB server OS: select * from tab order by foo collate "Polish, Poland" select * from tab order by foo collate "pl_PL.UTF-8" (that`s how it works now, correct?) Greetings Marcin Mańk