Kbase 19155: I18N. CONTAINS Still Not Working With German9 Collation
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/30/2009 |
|
Status: Verified
SYMPTOM(s):
QBW syntax error - an asterisk (*) is allowed only at the end of a word. (4686)
FACT(s) (Environment):
Progress 9.0A
CAUSE:
The word break rules are not set correctly.
FIX:
Follow these steps to fix the problem:
1) Find out the database code page.
2) If the database has no German9 collation, load it.
Depending on the database code page, use following files:
database code page file to load
------------------ ------------
1252 %DLC%\PROLANG\GER\ger91252.df
iso8859-1 %DLC%\PROLANG\GER\ger9is01.df
3) Depending on the database code page, compile the new version of word break table to a number <N>:
proutil <database> -C wbreak-compiler <file-name> <N>
where <N> is number between 1 and 255, <file-name> is:
database code page <file-name> to compile
------------------ ----------------------------
1252 %DLC%\PROLANG\CONVMAP\m1252bas.wbt
iso8859-1 %DLC%\PROLANG\CONVMAP\iso01bas.wbt
4) Place the newly-created file proword.<N> in %DLC% or define environment variable PROWD<N>=<file-directory>\proword.<N> (In Version 9.0A, you must set PROWD<N>.)
5) Apply the new word-rules to the database:
proutil <database> -C word-rules <N>
6) Rebuild the word indexes:
proutil <database> -C idxbuild <ALL or word indexes>