VERIFIED SOLUTION i

Resolve error 'Cannot resolve the collation conflict between "" and "" in the equal to operation' in Portrait Dialogue

Product Feature: Plugins / Functions
Database: SQL Server
 

Issue

Send SMS operation is failing due to error  'Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation' is encountered'.

Following error is resorded in the dialogue server error log:
====================================
Dialogue Server: Dialog: 20170913_SBI_0_Activation_47010 (1623)
Dialogue Server: Operation: Send SMS (3806)
Dialogue Server: Branch#: 1
Dialogue Server: Exception type: EOleException
Dialogue Server: Error message: PD-10000(1): Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation PD-10000(1): Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation
Dialogue Server: SCRIPT ERROR OBJECT PROPERTIES:
Dialogue Server: * Description: PD-10000(1): Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation
Dialogue Server: * Source: MHDialogServer.MHParticipantContainerServices
Dialogue Server: * Line: 119 , Column: 6
Dialogue Server: * Error number: -2147418113
Dialogue Server: * Text (source snippet):
Dialogue Server: Operation failed
====================================

Cause

This could occur due to mismatch between collations of two data values being compared.

Resolution

UPDATED: November 2, 2017
database .Collations are needed and used when ordering and comparing strings. It's a good idea to have a single and unique collation used throughout a

Following is the SQL query check collations of each column in table(s)
SELECT col.name, col.collation_name FROM sys.columns col WHERE     object_id = OBJECT_ID('YourTableName')

For detailed information about the error and possible resolution, refer following URL.
  1. Fix an error: Cannot resolve
  2. Receiving collation conflict