Kbase P97493: Incorrect conversion of a database to UTF-8 can result in error (1422) when trying to update non-asc
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/01/2011 |
|
Status: Verified
SYMPTOM(s):
Incorrect conversion of a database to UTF-8 can result in error (1422) when trying to update non-ascii fields.
SYSTEM ERROR: Index in for recid could not be deleted. (1422)
FACT(s) (Environment):
Records contain character fields
Character fields contain non-ascii data
Progress 9.x
All Supported Operating Systems
CHANGE:
Converted database to UTF-8
CAUSE:
%DLC%\prolang\utf\_tran.df left out of conversion process.
FIX:
Use the Data Administration tool to load the file %DLC%\prolang\utf\_tran.df to change database collation.
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).