Catalog search limitations
If you choose to implement catalog search functionality for your site, you should be aware of the limitations explained in this section.
- Case-insensitive searches are not permitted on the CATENTDESC long description column. This is because of potential performance degradation when using the upper() function on the columns CLOB data type.
- The CATENTDESC long description column is not intended for searching. To facilitate searching, use the short description and keyword columns. The data type of these columns is VARCHAR(254), which allows for better search performance than CLOB.
Related tasks
Add catalog search to your siteRelated reference
Catalog search performance