Error = collation conflict cant fathom

CgaskellCgaskell Posts: 4
edited January 31, 2006 1:38PM in SQL Compare Previous Versions
Morning,
we use your software to synronise a master SQL Database with local SQL server databases. We have been using it for the past 10 months with no issue however just recently we have been receiving this error message

"Cannot resolve collation conflict for equal to operation."

This has occoured on a varchar(50) field which is never created on the local server. The master database has a collation type of Latin1_General_CI_AS.

Can you give us any pointers?

Regards,
Chris.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,

    This reads like it could be a problem copying data from one column to another where the collation order is different. Probably as the result of a tabe rebuild. You might try the 'ignore collation order' option to keep the script from specifying a collation order. Of course if this is a SQL 7 database, this probably won't help.
  • Hi,

    Thanks for that, is it possible to add options.default and options.IgnoreCollations ?

    only we already had options.default which we've now changed to options.IgnoreCollations and this has now produced an error message of

    "Cannot use TEXTIMAGE_ON when a table has no text, ntext, or image columns."

    Any help more than appriciated!

    ta
  • Hi,

    OK to go 1 stage further, I've added a couple of fields with a data type of "text" and this has got rid of the previous message.

    However the "Cannot resolve collation conflict for equal to operation." is now back.

    I've used the Options.IgnoreCollations everywhere possible :(

    ta....
Sign In or Register to comment.