Thread: Text-Varchar Truncation via 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
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

JPTrue@aol.com wrote:
>
> 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).

Did you try to turn on *Text As LongVarchar* option ?

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/

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