Skip to Main Content

difference between {dou}% and dou% ?

719445Jan 12 2010 — edited Jan 13 2010
What'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.
Comments
Post Details
Added on Jan 12 2010
1 comment
2,235 views