Hi - I need to change a collation of a field.
The field is varchar(20).
I need to change it, from SQL_Latin1_general_cp1_CI_AS to latin1_general_ci_as.
Someone created this field with this collation, but i need to put the collation equal to the other tables.
This field as only data , like this : s4.01-12312 or like this 0000233
Can i lose data when changing the field collation?
P.S when changing the collation of this field, i receive the folowing message:
Server: Msg 5074, Level 16, State 8, Line 1
The index 'Indice_RGC' is dependent on column 'RGC'.
Server: Msg 4922, Level 16, State 1, Line 1
ALTER TABLE ALTER COLUMN RGC failed because one or more objects access this column.
Do i have to disable the index and then enable it after the collation alter?