Selecting Collation for International application

view story

http://serverfault.com – We are installing a new SQL Server 2012 Enterprise that is to be deployed in different countries around the world. All the servers is going to share data in real time, and the application is connecting to the server giving the fastest respone. So if I run the application in Norway, I could get the result from a server in Sweden. I’m having a struggle with selecting the best Collation for the server’s. The main office is in Norway some I would usually select the Norwegian_100 Collation, but when placing servers in different countries I believe that all the servers should have the same Col (HowTos)