Text-Varchar Truncation via ODBC - Mailing list pgsql-odbc

From Peter Staudt
Subject Text-Varchar Truncation via ODBC
Date
Msg-id 000101c26560$d65f22a0$09092bac@vishay.com
Whole thread Raw
In response to Text-Varchar Truncation via ODBC  (JPTrue@aol.com)
List pgsql-odbc
Hi Jeff,

>
> Hello,
> I am using a variety of programs to attach to a PostGreSQL
> database via ODBC, including MS Access 2000 and MS DTS 7.0.
>
> Any column in my PostGreSQL database with a datatype of TEXT of
> VARCHAR(n) is limiting/truncating INSERTed or UPDATEd data to
> ~255 characters.
...
Hmmm, maybe this one is not of much use for you,
but I thought the 255 characters are a M$ Access limitation and
you have to use "memo" type fields if you need more than 255.

CU,
Peter

pgsql-odbc by date:

Previous
From: ggorcsos
Date:
Subject: ODBC SQL connect problem
Next
From: Michael Meskes
Date:
Subject: [s.hetze@linux-ag.de: PostgreSQL integration Visual Basic, SQLProcedureColumns]