| Subject | RE: [firebird-support] Migrating some columns from win1250 to utf8 |
|---|---|
| Author | Helen Borrie |
| Post date | 2009-02-02T09:35:05Z |
At 07:38 PM 2/02/2009, Set wrote:
where 'x' is the same size for both oldfield and newfield
./heLen
>1. Take a backup of your database (nice to have)3. update mytable set newfield = cast (oldfield as varchar(x) character set utf8)
>2. Create a new field with the desired character set and commit
>3. Copy the contents of the old field to the new field and commit (UPDATE MyTable SET NewField = OldField)
where 'x' is the same size for both oldfield and newfield
./heLen