oracle text: sanitize user input


if anyone trust controlling seer calm (ctxsys.context), i'm wondering hoop user quarrel user wants hunt names competence enclose an apostrophe.



escaping ' seems work cases, nonetheless 's during finish - s list stop words, seems removed.



we now change rudimentary query calm (i.e. anything that's only letters) %text%, example:



contains(field, :text) > 0


a hunt o'neil works, nonetheless joe's doesn't.



has anyone controlling seer calm dealt issue?



Comments

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members