Text-Varchar Truncation via ODBC

From: Peter Staudt <Peter(dot)Staudt(at)Vishay(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Text-Varchar Truncation via ODBC
Date: 2002-09-26 13:30:10
Message-ID: 000101c26560$d65f22a0$09092bac@vishay.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2002-09-26 23:48:10 Re: Text-Varchar Truncation via ODBC
Previous Message JPTrue 2002-09-26 13:03:15 Text-Varchar Truncation via ODBC