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

From: "filippo" <filippo2991(at)virgilio(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: perl DBI: problems searching text strings with ' symbol (es d'ambrose)
Date: 2007-04-06 23:47:08
Message-ID: 1175903228.842826.17400@l77g2000hsb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7 Apr, 01:26, "filippo" <filippo2(dot)(dot)(dot)(at)virgilio(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John D. Burger 2007-04-07 00:03:42 New to concurrency
Previous Message Tom Lane 2007-04-06 23:43:50 Re: performance; disk bad or something?