From: "Cary O'Brien" <cobrien@Radix.Net>
Message-Id: <199908031526.LAA27120@saltmine.radix.net>
Subject: Applix Data, BLOBS and PostgreSQL data types.
To: applixware-list@applix.com
Date: Tue, 3 Aug 1999 11:26:34 -0400 (EDT)
Cc: pgsql-interfaces@hub.org
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit


What data ODBC data types does Applix Data think are blobs?  I'm using PostgreSQL
via ODBC.  I can turn all text/varchar to blobs with the TextAsLongVarchar=1 flag,
but what I want is for some text fields to be text, and some to be blobs.  I.e.
text fields blobs and varchar fields not blobs, or the other way around.

I think this depends on which of the following SQL data types are interpreted
as blobs by Applix Data (from isqlext.h):

# define SQL_LONGVARCHAR                (-1)
# define SQL_BINARY                     (-2)
# define SQL_VARBINARY                  (-3)
# define SQL_LONGVARBINARY              (-4)

I realize this is mostly a PostgreSQL ODBC driver issue, and I am willing
to fix the driver, but I need to know which ODBC data types I need for
BLOB and NON-BLOB text.

Thanks,

-- cary

Cary O'Brien
cobrien@radix.net