Re: int8 vs text in odbc link

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
Subject: Re: int8 vs text in odbc link
Date: 2000-10-15 20:12:28
Message-ID: 5449.971640748@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pawel Zaorski 2000-10-15 21:28:08 Re: dissallowing access to databases
Previous Message Martin Gainty 2000-10-15 19:03:07 Re: can I define own variables?