DB Collation change Impact

• GonnaCatchIT

  SSCrazy

  Points: 2797

  More actions

  August 5, 2015 at 3:28 am

  #310535

  Hi All,

  Our SQL Server 2008 r2 has collation Latin general.

  And my database 'DB1' , 'DB2' has collation set to Japanese unicode.

  My sql team has informed they cannot change system collation as it hosts other db's as well.

  My Query: What will be the impact of changing collation from JP to Latin. Any pointers will help.

• JohnG69

  Hall of Fame

  Points: 3114

  More actions

  August 5, 2015 at 7:18 am

  #1817503

  You can change the collation at the DB Level but, If I'm not mistaken, it will not change your data.

  the columns will stay in the old collation.

  you will need to change the collation of each column.

  not sure if you have to transfer the data to new columns with the new collation.

  this link will help you understand...