Post reply

Collation conflict

  • June 14, 2010 at 6:49 pm

    #236444

    When two databases have different collations, and when we use the JOIN statement, we got the error beloe.

    Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

    Any idea how to fix it?

    Many thanks in advance.

  • June 14, 2010 at 11:47 pm

    This was removed by the editor as SPAM

  • June 15, 2010 at 6:13 am

    #1180332

    you can change the collation in the query or change the data type to var binary for the fields to be matched

    Venkat
    http://sqlblogging.blogspot.in

  • June 15, 2010 at 6:53 am

    This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply