Hi all,
In Windows 7, and using PostgreSQL 9.4.5, the collation gets set to "English_United States.1252" when I select the "English, United States" locale in the installer. In Linux, the collation is set to "en_US.UTF-8". The encoding is set to UTF-8 in both instances.
Will these two instances behave identically in terms of collation logic? And if not, is there something I can do about it? In general, what's the impact of the codepage part of a collation to begin with?
Cheers,
Raimo