Subject Re: [firebird-support] changing character set
Author Anderson Farias
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