Case-sensitivity

[skalyanaraman]

Hi,
I know that when I do a regular query like,
select * from tbldoc where AUTHOR like 'charlie'

the query term charlie is case-insensitive, by that I mean I get search hits back for Charlie, CHARLIE and so on..

But in our application we have a section where we query against the index like,

"set indexaccess=1;set matchmode=1;select * from idxmAUTHOR where Word matches 'charlie';"

But here I dont get hits back if I change the charlie above to Charlie.
Why?? What do I need to do to fix it? Is it how it is supposed to work??

Thanks in advance for the help!!

[John]

Yes, that's how it is supposed to work. The index only stores the lowercase form of words found, which makes for a more efficient index.

[mark]

Solution: lowercase your term before looking it up.