Kbase P12863: Database corruption after a code page conversion
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Database corrupted after codepage conversion
Errors querying converted table/data
Binary dump/load was used during the conversion process
bfx: Field too large for a data item. Try to increase -s. (42)
CHANGE:
Converted database to UTF-8
CAUSE:
Binary dump does not record the code page of the text being written to the dump file. Therefore, users should only perform a binary load of dumps to databases of the same code page as the original (dumping) database. A conversion of the text from the dump code page to the loading database's code page is not performed. It is performed with ADMIN dump and load. A binary dump/load should not be used as part of a code page conversion.
FIX:
Trying to fix the corrupted database could lead to far worse corruption. The best solution is to restore the backup copy of the database, then convert that database. If a dump/load is part of the conversion process you should do a data dictionary dump/load.