Re: [INTERFACES] M$-Access'97 and TIMESTAMPs

Jose' Soares Da Silva wrote:

> Also the following types are recognized as text:
> int28
> oid8
> oidint2
> oidint4
>

Just a little history here...any data type that is not directly supported by the
odbc driver will get mapped to SQL_VARCHAR or SQL_LONGVARCHAR, depending on
driver 'data type options'. That allows you to view it and possibly update it,
if there is an appropriate operator. This is great compared to what the driver
used to do in the old days with unsupported types (i.e., crash with no
descriptive error message)!

For int28 and oid8, there is no SQL data type that maps. Text is the only way to
display it that I know of.

oidint2 and oidint4 are just integers I guess, and probably could be mapped to
SQL_SMALLINT and SQL_INTEGER, respectively.

Byron