Thread: Re: perl DBI: problems searching text strings with ' symbol (es d'ambrose)

On 7 Apr, 01:26, "filippo" <filippo2...@virgilio.it> wrote:
> hello,
>
> if I try to insert text like
>
> $dbh->quote(qq/d'ambrose/);
>
> when I try to search names with character lile ', I get this error

I forgot to say that I need LIKE and %. I tried to use placeholders
but nothing changes.

On 7 Apr, 01:47, "filippo" <filippo2...@virgilio.it> wrote:
> On 7 Apr, 01:26, "filippo" <filippo2...@virgilio.it> wrote:

just to clarify:

I can insert text into database. My problem are the SELECT query like
this

WHERE name LIKE $name

$name = $dbh->quote(qq/ d'am% / )

On 7 Apr, 10:13, "filippo" <filippo2...@virgilio.it> wrote:

solved, it is a DBD::PgPP bug. I changed to DBD::Pg, now it works fine.