Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Collation mismatch
Message
From
12/01/2021 13:21:20
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Troubleshooting
Title:
Collation mismatch
Miscellaneous
Thread ID:
01677816
Message ID:
01677816
Views:
35
I am getting an error, Cannot resolve the collation conflict between xxx and yyy in the equal to operation.

When I am checking the collation setting, strange thing is that I get two records:

SELECT
col.name, col.collation_name, Object_ID('Spouse'), Object_Name(Object_ID('Spouse'))
FROM
sys.columns col
WHERE
col.name = 'spFirst'

SpFirst SQL_Latin1_General_CP1_CI_AS 187915791 Spouse
spFirst Latin1_General_CI_AS 187915791 Spouse

So the second row show the same field name in lower case with a different collation than the table has.

EXEC sp_help Spouse
Shows only fields with the correct collation. Where does this second collation come from, and how can I modify the mismatched collations?
Christian Isberner
Software Consultant
Next
Reply
Map
View

Click here to load this message in the networking platform