Postgres Pro
Downloads
Home   >   mailing lists

Re: perl DBI: problems searching text strings with ' symbol (es d'ambrose) - Mailing list pgsql-general

From filippo
Subject Re: perl DBI: problems searching text strings with ' symbol (es d'ambrose)
Date
Msg-id 1175903228.842826.17400@l77g2000hsb.googlegroups.com
Whole thread Raw
Responses Re: perl DBI: problems searching text strings with ' symbol (es d'ambrose)  ("filippo" <filippo2991@virgilio.it>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Tonnerre LOMBARD
Date:
Subject: Index "misbehavior" in PostgreSQL 8.2.2?
Next
From: Klaas Dellschaft
Date:
Subject: Problem with copying data