In countries outside the US, the collation of the sql server is based on windows locale and the default during a sql installation for most non-US countries particularly in Europe is Latin1 versus the SQL Latin1 which is the official collation of t...