Kbase P105850: How to make special characters in a CONTAINS phrase searchable ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/30/2009 |
|
Status: Verified
GOAL:
How to make special characters in a CONTAINS phrase searchable ?
GOAL:
How to treat & ! ^ | in a CONTAINS phrase as normal characters ?
GOAL:
How to make ampersand searchable in word index ?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
The ampersand and other special characters that can be used in a contains phrase can be made searchable simply by adding them to a custom word-break table and using that table on the database.
Do note that this approach will effectively remove all special functionality of the character, so any query using the character in a CONTAINS phrase may return different results after applying the new word break rules.