--- In firebird-support@yahoogroups.com, "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

there.

>
> > 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

<yourfieldname>

> <fieldtype/domanin>)
> pump data from old field (<tempfieldname>) to new field

(<yourfieldname>)

> 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.