perl DB (pgsql)I: problems searching text strings with ' symbol (es d'ambrose)

F

Filippo

hello,

if I try to SQL SELECT LIKE for a string containing single quote:

my $name = $dbh->quote(qq/d'ambr%/);
SELECT name FROM mytable WHERE name LIKE $name

I get this error

DBD::pgPP::st execute failed: Unknown message type: '­' at C:/Perl/
site/lib/DBD/
PgPP.pm line 730

I have no problems inserting text

How can I solve it?

p.s.
I really need LIKE and %
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,901
Latest member
Noble71S45

Latest Threads

Top