Best way to Handle Collation Differences.

• Peter Clements-368786

  SSC Enthusiast

  Points: 159

  More actions

  February 26, 2010 at 7:58 am

  #211741

  Hi,

  I am delivering a 2008 database solution to client sites where I do not have control over the server collation. My intention is to provide the populated database as a backup to the clients. I am not sure of the best way to handle collation diferences - the database bing deployed contains bound views that precludes a simple collation change of the database being deployed. I also cannot dictate collation of the server at client site

  Any tips to gracefully handle this will be gratefully received.

  Pete Clements.

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 26, 2010 at 8:28 pm

  #1125913

  I'm not sure that the links listed below will help you.

  You may have to work from a Development Server that has both SQL Server 2005 & SQL Server 2008 to accomplish this task.

  Collation Types

  http://msdn.microsoft.com/en-us/library/ms175194.aspx

  SQL Server 2008 Collation Setting and Windows Versions

  http://www.sqldev.org/sql-server-setup--upgrade/sql-server-2008-collation-setting-windows-versions-94308.shtml

  SQL SERVER – Cannot resolve collation conflict for equal to operation

  http://blog.sqlauthority.com/2007/06/11/sql-server-cannot-resolve-collation-conflict-for-equal-to-operation/

  Regards,

  WC

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/