Post reply

collation conflict

  • May 30, 2008 at 4:19 am

    #71422

    HI,

    While I am adding 3 columns into one column I am getting the following error.

    'Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict'.

    All the columns are varchar type.

    Can any one help me.

    Thanks and Regards

  • May 30, 2008 at 6:52 am

    #822275

    Are the colomns in the same database or are you joining between seperate databases ?

  • May 30, 2008 at 7:28 am

    #822300

    Hi,

    If you are taking column from different database then when you join two column you have to specify "collate latin1_general_ci_as" after name of the column.

    say left outer join on this.that = that.this collate latin1_general_ci_as

    regards,

    vijay

  • June 6, 2008 at 8:39 am

    #825497

    Hi,

    No they are come from temp tables in one database.

    Thanks

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

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