Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 8485B9FA2BB for ; Fri, 2 Feb 2007 01:33:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 00501-02 for ; Fri, 2 Feb 2007 01:33:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 241909F9EF0 for ; Fri, 2 Feb 2007 01:33:05 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id B6F9B30AE1; Fri, 2 Feb 2007 06:33:01 +0100 (MET) From: ellis@spinics.net X-Newsgroups: pgsql.interfaces.php Subject: Re: pg_[un]escape_bytea, pgsql 8.2.1, php 5.1.6, Linux Date: Fri, 02 Feb 2007 05:32:59 -0000 Organization: S.P.C.A.A. Message-ID: <1170394379.757745@no.spam> References: <302670f20702011827x28d9a689m388b2c8a703f31af@mail.gmail.com> X-Newsreader: trn 4.0-test76 (Apr 2, 2001) Originator: ellis@no.spam () Cache-Post-Path: no.spam!unknown@no.spam X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 11 To: pgsql-php@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.962 tagged_above=0 required=5 tests=BAYES_50, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200702/11 X-Sequence-Number: 3694 In article <302670f20702011827x28d9a689m388b2c8a703f31af@mail.gmail.com>, Gary Chambers wrote: >I have inserted (via pg_query_params) into a bytea field some >binary data (a JPEG image in this case) which I have escaped >using pg_escape_bytea. I just use a text field and base64 encode the image. It works great. -- http://yosemitephotos.net/