There are compilation issues in our TFS builds since some non-English characters are not recognized. Could this be caused by SQL Server collation? Its been installed as
SQL_Latin1_General_CP1_CI_AS (not locale-specific).
Update: Thanks to both answers for leading me to the right direction. This article also may help other people with the same problem.