Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Collation mismatch
Message
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Dépannage
Titre:
Collation mismatch
Divers
Thread ID:
01677816
Message ID:
01677816
Vues:
36
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform