Hi emb_blaster,

> as I feared... I was thinking in creating temporary tables copy the
> data from original ones, drop original ones. Then I can recreate with
> the correct colation and insert the data from temporary table. I don´t
> see another way... there´s any?

Just creating a new column ought to be enough. Create it with the desired collation, then:

update table MyTable set NewColumn = OldColumn

After that:

alter table MyTable drop OldColumn

Then rename the new column:

alter table MyTable alter NewColumn to OldColumn

And optionally reposition it to where the original OldColumn used to be:

alter table MyTable alter OldColumn position ...


Greetings,
Paul Vinkenoog