Post reply

collation error

  • March 8, 2011 at 10:07 pm

    #246593

    Hi,

    Iam getting error like

    Implicit conversion of varchar value to varchar can not be performed because the collation of the value is unsolved due to collation conflict

    I have changed the x Database colaation from Latin1_General_CI_AI to SQL_Latin1_General_CP1_CI_AS but

    How to change the collation of all the existing objects (at once) inside a that x database

    Thanks in advance

  • March 9, 2011 at 10:11 pm

    #1296879

    Please update to fix above error

  • March 10, 2011 at 4:45 am

    #1296994

    I think you would need to copy the data into new tables ... not fun, but maybe someone else has details ?

    You can use COLLATE in your queries to allow them to run.

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

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