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

[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:gPP::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 %

 

[Filippo]

(snip)

solved, it is a DBD:gPP bug. I changed to DBD:g, now it works fine.