in reply to regexp question

So why don't you
1) do your searches before encoding
or
2) decode to some temporary location for the purpose of searching
or
3) encode your search expression with the same encoder and procedure as well

...?

Replies are listed 'Best First'.
Re^2: regexp question
by Nodonomy (Novice) on Jan 29, 2011 at 17:21 UTC
    I believe #3 is the correct way.
[reply]
      No, it's a lot of needless work.
[reply]

        I think I know that now, thanks to Anonymous Monk. I will be using "prepared statements" in Java to load the SQL. As I understand it, then one does not have to encode text for insertion.

        Aren't I on the right track then Ikegami?

        I thought this link might be helpful for others:   Prepared SQL statements in Java

[reply]

In Section Seekers of Perl Wisdom