Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
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

...?

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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://885040]
help
Chatterbox?
and monks are getting baked in the sun...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (3)
As of 2016-12-04 07:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    On a regular basis, I'm most likely to spy upon:













    Results (63 votes). Check out past polls.