July 9, 2010 at 1:10 am
I have two tables in the same database. The server collation is set to Latin1_General_CI_AS , but the database and table columns are all set to SQL_Latin1_General_CP1_CI_AS. I have checked all indexes and they are also collated SQL_Latin1_General_CP1_CI_AS
I am getting a join error when i try and join a varchar field between the tables :
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
BUT both join fields are using SQL_Latin1_General_CP1_CI_AS.
I thought it might be dodgy data in the table (Incorrect for collation) so i created and empty copy of the table and same issue.
It is some how believing the column is collated Latin1_General_CI_AS even though the proerties say it is Latin1_General_CI_AS.
i dont know what else to look for ,
Very confused
July 9, 2010 at 3:17 am
This was removed by the editor as SPAM
July 9, 2010 at 3:38 am
Thanks for your reponse stewart .
The database and tables have the same collation and there fore i should not have to force collation.
It seems to be something to do with the actual database but i cant figure out what else it could be.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply