Re: bytea/ODBC/MSAccess issue - Mailing list pgsql-hackers

From Joe Conway
Subject Re: bytea/ODBC/MSAccess issue
Date
Msg-id 3C01ED1A.4070101@home.com
Whole thread Raw
In response to Re: bytea/ODBC/MSAccess issue  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-hackers
Hiroshi Inoue wrote:

>>-----Original Message-----
>>From: Tom Lane
>>
>>Joe Conway <joseph.conway@home.com> writes:
>>
>>>When creating a linked table in MS Access, bytea columns get mapped to 
>>>"OLE Object" as a datatype, and this type is not able to be indexed. 
>>>
>>Could we make our ODBC driver map bytea to some datatype that Access
>>doesn't choke on?
>>
> 
> IIRC our ODBC driver maps bytea to SQL_VARBINARY which is
> able to be indexed in MS Access. Probably Joe is changing the
> *Max Varchar* option > 255. 
> Currently the mapping of our driver is
>    SQL_VARBINARY (the length <= 255)     <---> bytea
>    SQL_LONGVARBINARY (the length can be > 255) <---> lo
> .
> MS Access couldn't handle the binary type index > 255 bytes.
> PostgreSQL hasn't been able to have indexes on bytea until
> quite recently and bytea is unavailable for LO. 
> Every application has its limitation.
> 
> regards,
> Hiroshi Inoue

Thanks for the reply, Hiroshi. This advice worked, and after a little
research I see (as you said) that the limitation is with MS Access -- so
not much we can do :(

Joe



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Call for objections: deprecate postmaster -o switch?
Next
From: Hannu Krosing
Date:
Subject: Re: OCTET_LENGTH is wrong