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
Non-existent; I don't have TV
Non-existent; my TV doesn't have/need a remote
Under my control; I watch alone
Under the control of whoever shouts loudest
Under the control of whoever gets it first
One of many, and the TV has a mind of its own
Results (584 votes),