Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

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
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

...?


Comment on Re: regexp question
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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (8)
As of 2014-09-01 12:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (9 votes), past polls