Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re: regexp question

by elef (Friar)
on Jan 29, 2011 at 17:17 UTC ( #885040=note: print w/replies, xml ) Need Help??

in reply to regexp question

So why don't you
1) do your searches before encoding
2) decode to some temporary location for the purpose of searching
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.
      No, it's a lot of needless work.

        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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://885040]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (13)
As of 2016-10-25 20:50 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (330 votes). Check out past polls.