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.
pgsql-odbc by date
|Next:||From: Peter Staudt||Date: 2002-09-26 13:30:10|
|Subject: Text-Varchar Truncation via ODBC|
|Previous:||From: Terry Yapt||Date: 2002-09-26 10:15:00|
|Subject: Delphi / ODBC / DataSet.RecordCount failed on 7.2.2|