We wrote a SP to compare and update two database structures (devel to live).
But now were getting a "Cannot resolve collate conflict for equal to operation."
for WHERE db1.Table_Name = db2.Table Name
We had a look at the server collate settings.
It turns out the the devel db is SQL_LATIN1_GENERAL_CP1_CI_AS
And the live system is LATIN1_GENERAL_CI_AS
They might be the exact spellings for those settings.
The point is, how do we fix this? We have no idea...
Cheers,
Jim.
But now were getting a "Cannot resolve collate conflict for equal to operation."
for WHERE db1.Table_Name = db2.Table Name
We had a look at the server collate settings.
It turns out the the devel db is SQL_LATIN1_GENERAL_CP1_CI_AS
And the live system is LATIN1_GENERAL_CI_AS
They might be the exact spellings for those settings.
The point is, how do we fix this? We have no idea...
Cheers,
Jim.