Kbase 21838: ERROR (1422) Caused By Incorrect UTF-8 Database Conversion
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/03/2002 |
|
SUMMARY:
Incorrect conversion of a database to UTF-8 can result in error (1422) when you try to update non-ascii fields:
SYSTEM ERROR: Index in for recid could not be deleted. (1422)
EXPLANATION:
In the process of conversion to UTF-8, the %DLC%\prolang\utf\_tran.df; used to change the database collation, must be added via the Data Administration tool. If this file is left out of the conversion process, any attempts to update non-ascii characters can result in System Error (1422).
NOTE: Running idxbuild will clean up the errors temporarily. However, a new attempt to update a field with a non-ascii character will again bring about the error.
SOLUTION:
Go through the conversion process as shown in Progress Knowledge Base Solution 19912, "Converting an Existing Database to UTF-8".
References to Written Documentation:
Progress Internationalization Guide
Progress Database Administration Guide and Reference
Progress Knowledge Base Solution 19912, "Converting an Existing Database to UTF-8"