Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group