Postgres Pro
Downloads
Home   >   mailing lists

Re: int8 vs text in odbc link - Mailing list pgsql-general

From Tom Lane
Subject Re: int8 vs text in odbc link
Date
Msg-id 5449.971640748@sss.pgh.pa.us
Whole thread Raw
In response to int8 vs text in odbc link  (Andrew Gould <andrewgould@yahoo.com>)
List pgsql-general
Tree view 
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?

            regards, tom lane

pgsql-general by date:

Previous
From: "Len Morgan"
Date:
Subject: Re: int8 vs text in odbc link
Next
From: zaor@sky.pl (Pawel Zaorski)
Date:
Subject: Re: dissallowing access to databases