Re: Can't get more than 255 chars out of memo field in Acc - Mailing list pgsql-odbc

From Tom Lane
Subject Re: Can't get more than 255 chars out of memo field in Acc
Date
Msg-id 21355.1038426981@sss.pgh.pa.us
Whole thread Raw
In response to Re: Can't get more than 255 chars out of memo field in Acc  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Responses Re: Can't get more than 255 chars out of memo field in Acc  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-odbc
Jeff Eckermann <jeff_eckermann@yahoo.com> writes:
> The implication is, there is no workaround.  You will
> need to change the table definitions in your
> PostgreSQL database to use varchar(n) datatypes
> whereever you want Access to see text.

I wonder whether we could/should hack our ODBC driver to report "text"
columns as "varchar(n)" (and if so, what n should we use)?  Seems like
enough people want to use Access that this would be a useful option.

            regards, tom lane

pgsql-odbc by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: Can't get more than 255 chars out of memo field in Acc
Next
From: Jeff Eckermann
Date:
Subject: Re: Can't get more than 255 chars out of memo field in Acc