Compiling, storing, and applying the UTF-8 word-break rules to a database

When you convert an existing database to UTF-8, whether you use the PROUTIL CONVCHAR utility or the DUMP and LOAD utilities, you must compile, store, and apply the UTF-8 word-break rules to the database.

If you forget to apply the word-break rules to your database, you might get the following symptoms:

Queries with the CONTAINS operator return incorrect results

A QBW syntax error saying that an asterisk (*) is allowed only at the end of a word

To compile, store, and apply the UTF-8 word-break rules to a database:

1. Compile a new version of the word-break table for UTF-8 using the syntax for your specific operating system, where number indicates an INTEGER between 1 and 255:

Windows syntax	proutil -C wbreak-compiler %DLC%\prolang\convmap\utf8-bas.wbt number
UNIX syntax	proutil -C wbreak-compiler $DLC/prolang/convmap/utf8-bas.wbt number

This produces a new word-break table, proword.number.

2. Store the new word-break table using one of the following options:

Store it in the $DLC directory on UNIX or in the %DLC% directory on Windows

Store it in an arbitrary directory, then set the environment variable PROWDnumber to the value of the arbitrary directory

3. Apply the new word-break rules to the database using the following syntax:

proutil database-name -C word-rules number