just use: SELECT * FROM A JOIN B ON A.Text = B.Text COLLATE Latin1_General_CI_AS or using default database collation: SELECT * FROM A JOIN B ON A.Text = B.Text COLLATE DATABASE_DEFAULT

https://stackoverflow.com/questions/17616620/cannot-resolve-collation-conflict#17617060

same for error: Cannot resolve the collation conflict between "Thai_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. 02.07.20

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2025