Kbase P27606: Index corruption on database that was converted to utf-8.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/06/2003 |
|
Status: Unverified
SYMPTOM(s):
Index corruption on database that was converted to utf-8.
Unable to create new records when primary field entry begins with the same extended character as an existing record.
Records may be found using indexes after it was created.
Unable to find records using indexes when indexes are rebuilt.
proutil db-name -C idxbuild ALL -cpinternal utf-8
CAUSE:
When database was converted to utf-8 the _tran.df was not applied.
FIX:
Load _tran.df from the %DLC%\prolang\utf directory and then rebuild the indexes.
ie.
Use Data Administration tool to load the file %DLC%\prolang\utf\_tran.df in order to change the database collation.
To Rebuild Indexes:
proutil db-name -C idxbuild ALL -cpinternal UTF-8
For additional information on converting existing databases to UTF refer to Solution 19912 How to convert an existing database to Unicode UTF-8.