Re: int8 vs text in odbc link

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Andrew Gould" <andrewgould@yahoo.com>
Cc: <pgsql-general@postgresql.org>
Sent: Sunday, October 15, 2000 9:12 PM
Subject: Re: [GENERAL] int8 vs text in odbc link


> Andrew Gould <andrewgould@yahoo.com> writes:
> > Unfortunately, all of the columns of the data
> > type int8 are interpreted as text in MS Access 97 when
> > you look at the design view of the table.
>
> Offhand it looks like our ODBC driver will report the type of an int8
> field as "SQL_BIGINT" (-5), which may or may not be a standard ODBC
> type code --- and even if it is, Access might not know it.  Anybody
> know?
>
Access 97 has Integer as 16-bit and Long Integer as 32-bit - those are the
only options available AFAICT.

- Richard Huxton