Changing the Data Type

• pmathema1

  SSC Enthusiast

  Points: 151

  More actions

  April 2, 2009 at 12:18 pm

  #203142

  Hi,

  I have a field of FLOAT type. I have to change it to Varchar so that i can concatenate it with other fields.

  I used: alter table

  alter column column_name varchar(255)

  Now when i am trying to concatenate this with oher fields. I am getting error msg:

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

  The script was running okay until i changed the db collation to SQL_Latin1_General_CP1_CI_AS

  Any Help!!

  Thanks

• GSquared

  SSC Guru

  Points: 260824

  More actions

  April 2, 2009 at 12:30 pm

  #970996

  You're going to have to make sure that whatever you're concatenating it with is the same colation. You can use Convert for that.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• pmathema1

  SSC Enthusiast

  Points: 151

  More actions

  April 2, 2009 at 2:40 pm

  #971111

  Thanks, you were right. Different column had different collation.

  I used alter statement for each of the column and it worked.

  "ALTER TABLE Table_Name ALTER COLUMN Column_Name COLLATE SQL_Latin1_General_CP1_CI_AS"