Debasis Mohapatra

Debasis Mohapatra

  • NA
  • 381
  • 57.2k

Windows based program getting error from sql server

Apr 23 2019 6:38 AM
Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

Answers (3)

2
Debasis Mohapatra

Debasis Mohapatra

  • 0
  • 381
  • 57.2k
Apr 25 2019 3:32 AM
I got the solution. 
 
select *,l.name as Divname from DB_PL_SETUP.dbo.tbl_profile p inner join tbl_Location l on p.location collate SQL_Latin1_General_CP1_CI_AS =l.loccd where p.uid='admin' 
0
Mohsin Arif

Mohsin Arif

  • 307
  • 6k
  • 138.6k
Apr 25 2019 3:43 AM
its good 
0
Mohsin Arif

Mohsin Arif

  • 307
  • 6k
  • 138.6k
Apr 23 2019 6:43 AM
hi
please read this articale 
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/01671529-337a-474b-89d3-dc1fb21d641f/how-to-fix-an-errorquotcannot-resolve-the-collation-conflict-between?forum=transactsql