Portal Home > Knowledgebase > eCommerce > Cannot Resolve the Collation Conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

Cannot Resolve the Collation Conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

 

Synopsis:

This error will be displayed on your webstore:

 

Server Error in '/' Application.

--------------------------------------------------------------------------------

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

 

Source Error:

Line 73:             if (!m_DesignMode)

Line 74:             {

Line 75:             m_EntityHelpers.Add("Category", AppLogic.CategoryEntityHelper);

Line 76:             m_EntityHelpers.Add("Section", AppLogic.SectionEntityHelper);

Line 77:             m_EntityHelpers.Add("Manufacturer", AppLogic.ManufacturerEntityHelper);

 

Solution:

This is caused by the collation conflict of the Server SQL installed and Database. The database collation should be changed to the server SQL collation.

 

  1. Open the Database Management Console or DBMC in the server.
  2. The connection window will display. Enter the proper Connection and click Ok.
  3. The DBMC will detect those databases that have different collations and will be list down in the collation error
  4. Select the database and the small icon Change to Server Collation. Click on the icon and the DBMC will try to change the collation.
  5. Browse again the website once the database collation is successfully changed

 

Applicable Products:

All versions of Interprise Suite and Connected Business

 

 

 


Also Read