Subject Re: changing character set
Author Joao Henrique Levada
--- In, "Anderson Farias"
<peixedragao@...> wrote:
> Hi,
> > I have a domain for descriptions. It's OK if I change the domain
> > properties
> > to a new character set and collation?
> I don't think so as this would not change the data that is already
> > wich is the "correct" way to do it?
> AFAIK, the "correct" way is -- for each field you want to change:
> rename the field (alter table alter <yourfieldname> to <tempfieldname>)
> create the field with new charset/collation (alter table add
> <fieldtype/domanin>)
> pump data from old field (<tempfieldname>) to new field
> drop the old field (alter table drop <tempfieldname>)
> Regards,
> Anderson Farias
Drop a Field?

"May the dependencies NOT be with you!" - Master Yoda.

Good luck.