Re: bytea/ODBC/MSAccess issue

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