X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C99E99DCAA8 for ; Wed, 30 Nov 2005 05:45:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04122-05 for ; Wed, 30 Nov 2005 05:45:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.pzkagis.cz (gis6.netbox.cz [83.240.30.214]) by postgresql.org (Postfix) with ESMTP id BAFAD9DCAB1 for ; Wed, 30 Nov 2005 05:45:14 -0400 (AST) Received: (from luf@localhost) by smtp.pzkagis.cz (8.11.6/8.11.6) id jAU9j9406126; Wed, 30 Nov 2005 10:45:09 +0100 Date: Wed, 30 Nov 2005 10:45:09 +0100 From: Ludek Finstrle To: Irina Sourikova Cc: pgsql-odbc@postgresql.org Subject: Re: BLOB handling compatibility with PostgreSQL > 7.4 Message-ID: <20051130094509.GA6109@soptik.pzkagis.cz> References: <438B792D.6030802@bnl.gov> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <438B792D.6030802@bnl.gov> User-Agent: Mutt/1.4i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/238 X-Sequence-Number: 6474 > We use unixODBC-2.2.11 and psqlodbc-08.01.0101. I don't exactly know how it's on linux. But which version of psqlodbc do you use (unicode x ansi). Try the second type and let us know if it helps. > With postgres 7.3 lo type was mapped to SQL_C_BINARY and that's changed > since postgres 7.4. That's changed to what type? Luf