Kbase 19944: CONTAINS Not Working With UTF-8 Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.0x
SYMPTOM(s):
QBW syntax error - an asterisk (*) is allowed only at the end of a word. (4686)
Query uses the CONTAINS operator
Database uses Unicode UTF-8
FIX:
If you converted existing database to UTF-8 database, refer to Progress Solution 19912 and make sure you perform all the necessary needed steps.
If you created your database from an empty UTF-8 database, follow these steps:
1) Compile a new version of the word break table for UTF-8 to a rule number <N>:
proutil <database> -C wbreak-compiler %DLC%\prolang\convmap\utf8-bas.wbt <N>
(where <N> is number between 1 and 255).
2) Place the newly-created file proword.<N> in %DLC% or define the environment variable:
PROWD<N>=<file-directory>\proword.<N>
(in Progress Version 9.0A, you must set PROWD<N>).
3) Apply the new word-rules to the database:
proutil <database> -C word-rules <N>.
4) Rebuild the word indexes:
proutil <database> -C idxbuild <ALL or word indexes> -cpinternal UTF-8