fulltext index: case sensitive vs. case insensitive
Thursday, 15 March 2012 · 2 messages · last reply 16 Mar 2012
CM
Cerstin Mahlow15 Mar 2012 17:28 #
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
--
Dr. phil. Cerstin Mahlow
Universität Basel
Deutsches Seminar
Nadelberg 4
4051 Basel
Schweiz
Tel: +41 61 267 07 65
Fax: +41 61 267 34 40
Mail: cerstin.mahlow at unibas.ch
Web: http://www.oldphras.net
---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.
CG
Christian Grün16 Mar 2012 18:36 #
Dear Cerstin,
Quoted text · Cerstin Mahlow · 9 lines
> 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!
..definitely something that should be covered by our new full-text index [1]
Thanks for your feedback; the more feature requests we get for the full-text index, the better we will know what this index must be tailored for.
Christian
[1] https://github.com/BaseXdb/basex/issues/346
Written for BaseX 7.1. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery