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
>