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!!
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!!
