Re: int8 vs text in odbc link

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

> Andrew Gould <andrewgould(at)yahoo(dot)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