Kbase P126299: Error 12371 converting the database to UTF-8
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/11/2007 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
SYMPTOM(s):
Error 12371 converting the database to UTF-8
Converting a database with proutil convchar convert to UTF-8 fails with 32K error exceeded.
Attempt to update data exceeding 32000. (12371)
SYSTEM ERROR: error attempting to update field OrderComment (3972)
SYSTEM ERROR: scanning records for table OrderDtl (3969)
** Conversion failed, database is unuseable. (3942)
CAUSE:
The field in question may not have 32K of data, but the total record length is approaching 32000 bytes. When converting the database to UTF-8 any extended characters can increase in storage space size from 1 byte to up to 4 bytes. The need to express extended characters in multiple bytes in UTF-8 has taken the total record length beyond the 32K limit.
FIX:
To resolve this problem reduce the record length to such an extent that the database can be converted. proutil tabanalys can be used to help with this since it displays the length of the longest record in each table.
After conversion, consider using CLOB fields to store such large amounts of data.