1,127
edits
Difference between revisions of "Case Insensitive Search"
m
Mentioned manual database updates.
m (Mentioned manual database updates.) |
|||
| Line 21: | Line 21: | ||
If the data you're indexing, searching for, and storing in CMOD requires case-sensitivity, there is no good solution to this issue, and end users should be instructed to pay close attention to proper capitalization. | If the data you're indexing, searching for, and storing in CMOD requires case-sensitivity, there is no good solution to this issue, and end users should be instructed to pay close attention to proper capitalization. | ||
The capitalization of a field cannot be changed after an Application Group has been created. | The capitalization of a field cannot be changed after an Application Group has been created. It *is* possible to update database tables manually, but this is not supported by IBM. | ||
Moving all characters to upper or lower makes it impossible to restore proper capitalization (McDonald, de Klock, Van Oster) | Moving all characters to upper or lower makes it impossible to restore proper capitalization (McDonald, de Klock, Van Oster) | ||
Storing characters in Mixed Case will reduce compression inside database tables, as "smith", "Smith", and "SMITH" are all different, and must be stored individually. | Storing characters in Mixed Case will reduce compression inside database tables, as "smith", "Smith", and "SMITH" are all different, and must be stored individually. | ||