Text-Varchar Truncation via ODBC

From: JPTrue(at)aol(dot)com
To: pgsql-odbc(at)postgresql(dot)org
Subject: Text-Varchar Truncation via ODBC
Date: 2002-09-26 13:03:15
Message-ID: 0BED6A39.194F4D66.00048176@aol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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.
I have tested and tried all variations of TEXT and VARCHAR(n) in my PostGreSQL database.
In addition, I have tried modifying all settings in the ODBC driver ( I am using version 7.02.00.02).

Any ideas, hints, or solutions would be greatly appreciated.

Thanks,
Jeff

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Peter Staudt 2002-09-26 13:30:10 Text-Varchar Truncation via ODBC
Previous Message Terry Yapt 2002-09-26 10:15:00 Delphi / ODBC / DataSet.RecordCount failed on 7.2.2