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
Post a Comment