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

Text-Varchar Truncation via ODBC

From: Peter Staudt <Peter(dot)Staudt(at)Vishay(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Text-Varchar Truncation via ODBC
Date: 2002-09-26 13:30:10
Message-ID: 000101c26560$d65f22a0$09092bac@vishay.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-09-26 23:48:10
Subject: Re: Text-Varchar Truncation via ODBC
Previous:From: JPTrueDate: 2002-09-26 13:03:15
Subject: Text-Varchar Truncation via ODBC

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