Re: Per-column collation

2010/11/16 marcin mank <marcin.mank@gmail.com>:
>> 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:

+1

Pavel

> 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
>