X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 79AD652871; Tue, 17 May 2005 15:30:20 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81448-05; Tue, 17 May 2005 18:30:11 +0000 (GMT) Received: from ns2.instrumentalyst.com (blk-222-55-203.eastlink.ca [24.222.55.203]) by svr1.postgresql.org (Postfix) with ESMTP id 833D352808; Tue, 17 May 2005 15:30:10 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ns2.instrumentalyst.com (Postfix) with ESMTP id 9F3973C1; Tue, 17 May 2005 15:32:30 -0300 (ADT) Received: from ns2.instrumentalyst.com ([127.0.0.1]) by localhost (ns2.instrumentalyst.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 37048-06; Tue, 17 May 2005 15:32:27 -0300 (ADT) Received: from [192.168.2.2] (pcp842727pcs.beridg01.fl.comcast.net [68.56.170.170]) by ns2.instrumentalyst.com (Postfix) with ESMTP id 8CD463BB; Tue, 17 May 2005 15:32:26 -0300 (ADT) Message-ID: <428A38DF.20802@productivitymedia.com> Date: Tue, 17 May 2005 14:33:03 -0400 From: Postgres Admin User-Agent: Mozilla Thunderbird 1.0+ (Macintosh/20050516) MIME-Version: 1.0 To: Scott Marlowe Cc: pgsql-php@postgresql.org, Sql-Postgre Subject: Re: [SQL] ERROR: unterminated quoted string... help References: <20050517170636.GC12405@phlogiston.dyndns.org> <428A2E81.2060501@pobox.com> <428A34D9.5000700@productivitymedia.com> <1116354432.22291.136.camel@state.g2switchworks.com> In-Reply-To: <1116354432.22291.136.camel@state.g2switchworks.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at instrumentalyst.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.083 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/30 X-Sequence-Number: 3144 Scott Marlowe wrote: > >Use a bytea field and use pg_escape_bytea() to prepare the data for >insertion. > > > Thanks Scott, I will try it now. J