Kbase P2895: Error 132 when adding records with Swedish data
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1A
HP-UX
SYMPTOM(s):
Error 132 when adding Swedish data
Adding a record with a unique key field set to 'ooo' returns the 132 error if a record already exists with this same unique key field set to 'ööö'. The same problem occurs when adding records with 'aaa' and 'äää'.
** <file-name> already exists with <field/value...>. (132)
CAUSE:
The database collation is set to "basic" when it should be using "Swedish" collation.
FIX:
Change the collation of the database from "basic" to "Swedish".
1) There is a file in the installation directory called "/prolang/swe/swe8859.df". This file needs to be loaded into the DB using the Data Administration tool. This will change the DB collation from basic to Swedish.
2) After loading the .df file rebuild the indexes with:
proutil <dbname> -C idxbuild
3) When this is done start the session and connect to the DB. The new collation should see the difference between 'ooo' and 'ööö', and so allow these records to be added.