pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Cary O'Brien <cobrien@Radix.Net>
To: applixware-list@applix.com
Cc: pgsql-interfaces@hub.org
Subject: Applix Data, BLOBS and PostgreSQL data types.
Date: Tue, 3 Aug 1999 11:26:34 -0400 (EDT)
Message-ID: <199908031526.LAA27120@saltmine.radix.net> (raw)




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





Message-ID: <199908031526.LAA27120@saltmine.radix.net>
Permalink:  ../199908031526.LAA27120@saltmine.radix.net/
Also on:    postgresql.org/message-id/199908031526.LAA27120@saltmine.radix.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: cobrien@Radix.Net, applixware-list@applix.com, pgsql-interfaces@hub.org
  Subject: Re: Applix Data, BLOBS and PostgreSQL data types.
  In-Reply-To: <199908031526.LAA27120@saltmine.radix.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox