Case sensitive or case insensitive? Totally confused now
445942Apr 14 2006 — edited Apr 14 2006Hi all
I have a development site with some records. I created a index on those records. Searching these records can be done case insensitive.
Now we are setting up our production server and put the same records with the same descriptions on that server. Created the same index on it. Strange thing is that all searches have to be made case sensitive to yield a result! Anybody knows what is going on?
Same version of the database (10.2) only difference is that one is on XP the other on Server 2003. Below is the index code.
CREATE INDEX DEMO_KEYWORDS_IDX ON DEMO_TEXT
(KEYWORDS)
INDEXTYPE IS CTXSYS.CONTEXT;