On Tue, Nov 16, 2010 at 10:32:01PM +0200, Peter Eisentraut wrote: > On tis, 2010-11-16 at 21:05 +0100, marcin mank wrote: > > 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" > > Sure that would be nice, but how do you hope to do that?
Given that each operating system comes with a different set of collations, it seems unlikely you could even find two collations on different OSes that even correspond. There's not a lot of standardisation here (well, except for the unicode collation algorithm, but that doesn't help with language variations). I don't think this is a big deal for now, perhaps after per-column collation is implemented we can work on the portability issues. Make it work, then make it better. </me ducks> Have a nice day, -- Martijn van Oosterhout <klep...@svana.org> http://svana.org/kleptog/ > Patriotism is when love of your own people comes first; nationalism, > when hate for people other than your own comes first. > - Charles de Gaulle
signature.asc
Description: Digital signature
