Postgres Pro
Downloads
Home   >   mailing lists

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

From JPTrue@aol.com
Subject Text-Varchar Truncation via ODBC
Date
Msg-id 0BED6A39.194F4D66.00048176@aol.com
Whole thread Raw
Responses Text-Varchar Truncation via ODBC  (Peter Staudt <Peter.Staudt@Vishay.com>)
List pgsql-odbc
Tree view 
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
datato ~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

pgsql-odbc by date:

Previous
From: Terry Yapt
Date:
Subject: Delphi / ODBC / DataSet.RecordCount failed on 7.2.2
Next
From: Hiroshi Inoue
Date:
Subject: Re: Text-Varchar Truncation via ODBC