Hi,
If I create the fulltext index with "stemming" switched on and "case sensitive" switched off, there is no way to enable case sensitive search, is this correct? So if users would like to search case sensitive as well as case insensitive, I would have to create two indices?
Which would mean creating actually four indices to allow for fuzzy search or exact matches as well:
w/ stemming and w/ case sensitive w/ stemming and w/o case sensitive w/o stemming and w/ case sensitive w/o stemming and w/o case sensitve.
That's quite a lot of data!
Would it be possible to handle case sensitivity rather as an option for the query than as an option for the index, like described here: http://www.xmlmind.com/tutorials/XQueryFullText/index.html#d0e333
Best regards
Cerstin