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: perl DBI: problems searching text strings with ' symbol (es d'ambrose)
Date: 2007-04-06 23:26:33
Message-ID: 1175901993.065182.9640@n76g2000hsh.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

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

I really need to store and select names with ' character, how can I
do?

Thanks,

Filippo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Danny E. Armstrong 2007-04-06 23:37:18 Re: YTA Time Zone Question
Previous Message Jeff Davis 2007-04-06 23:23:24 Re: Database replication.