Cannot resolve the collation conflict is Msg 468, and it appears when two text columns use different collations. I reproduced it on SQL Server 2025 with a temp table, found the mismatched columns with a query and tested three fixes, from a COLLATE clause in the query to changing the column itself.
Effect of Collation on Result Sets in SQL Server
The effect of collation on result sets is easy to see once you run the same query against two collations. This post builds a small demo and shows how sorting, comparing and grouping change. It also explains collation conflicts, including the one temp tables cause.
Moving From LocalDB to a Real Instance
Moving from LocalDB to a server instance takes a tested backup and restore, new connection strings, mapped logins, and a collation check.
Width Sensitive and Width Insensitive Collation: An Example
What is a width sensitive collation? I explain it with a simple example that compares half-width and full-width characters under both collation settings.
Storing Emoji and Short Messages: nvarchar, UTF-8 and Length
Store emoji safely with nvarchar or UTF-8 varchar, compare LEN and DATALENGTH, and choose message limits that fit full Unicode.
SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()
Is your database Case Sensitive? Find its collation, then look it up in fn_helpcollations() and read the description. A quick answer from my Office Hours.







