in reply to
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
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
Use two parentheses: (Like this: :) )
Use one parenthesis: (Like this: :)
Reverse direction of the smiley: (Like this: (: )
Use angle/square brackets instead of parentheses
Use C-style commenting to set the smiley off from the closing parenthesis
Make the smiley a dunce: (:>
I disapprove of emoticons
Results (630 votes),