difference between {dou}% and dou% ?
719445Jan 12 2010 — edited Jan 13 2010What's the difference between these two?
This causes DRG-51030 wildcard query expansion resulted in too many terms:
select * from news n where CTXSYS.CONTAINS(n.indexcol, '{dou}% ', 1) > 0
This results in 2364 rows.
select * from news n where CTXSYS.CONTAINS(n.indexcol, 'dou% ', 1) > 0
The reason I ask is because I am turning input from the user into a query, and it would be easier to just escape it all using {}, that way if the user types in OR, AND, or other search keyword, it wont break the query. But, I do want to add a % at the end.