Subject | Re: [firebird-support] changing character set |
---|---|
Author | Anderson Farias |
Post date | 2008-06-26T04:34:16Z |
Hi,
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
> I have a domain for descriptions. It's OK if I change the domainI don't think so as this would not change the data that is already there.
> properties
> to a new character set and collation?
> 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