Subject | RE: [firebird-support] Migrating some columns from win1250 to utf8 |
---|---|
Author | Svein Erling Tysvær |
Post date | 2009-02-02T08:38:43Z |
1. Take a backup of your database (nice to have)
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)
4. Delete the old field
5. Rename the new field and commit
I think it is preferable to be alone on the database when doing DDL (step 2, 4, and 5), though often things will work even though others are using the database.
HTH,
Set
-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of mulenker
Sent: 2. februar 2009 09:09
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Migrating some columns from win1250 to utf8
I want to migrate a Database from win1250 to utf8. If I change the
encoding of the columns, the contents of these colums is still in in
the win1252 encoding. How can i convert these contents to 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)
4. Delete the old field
5. Rename the new field and commit
I think it is preferable to be alone on the database when doing DDL (step 2, 4, and 5), though often things will work even though others are using the database.
HTH,
Set
-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of mulenker
Sent: 2. februar 2009 09:09
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Migrating some columns from win1250 to utf8
I want to migrate a Database from win1250 to utf8. If I change the
encoding of the columns, the contents of these colums is still in in
the win1252 encoding. How can i convert these contents to utf8.