Postgres Pro
Downloads
Home   >   mailing lists

Re: Invalid Blob length - Mailing list pgsql-novice

From Godshall Michael
Subject Re: Invalid Blob length
Date
Msg-id A596FA3368757645AF862C701495CA0001B44564@hor1mspmx01.gmachs.com
Whole thread Raw
In response to Invalid Blob length  ("Derrick Betts" <Derrick@grifflink.com>)
List pgsql-novice
Tree view
I don't know about BDE but the ODBC driver for postgres limits large text to about 500 characters by default.  That can be changed via the properties in the ODBC connection settings.  Maybe BDE does something similiar.  You might try searching the pgsql-odbc mailing list.
-----Original Message-----
From: Derrick Betts [mailto:Derrick@grifflink.com]
Sent: Wednesday, September 10, 2003 9:35 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Invalid Blob length

I am using a BDE connection from a windows app I'm building to connect to Postgres 7.3.2 running on Redhat on a linux box.
 
When I attempt to Post the dataset which I have loaded with a very large 'text' string, I get the following error:  Invalid Blob length.
 
The field on the table is a type 'text'.  The string that I am loading to the database is about 4,000 ascii characters long. (not really that large).
 
Any ideas as to why I am getting this error?  Is there a setting I need to change on the database?
 
Thanks for your help,
Derrick

pgsql-novice by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: phone number list
Next
From: Noel
Date:
Subject: Synchronising two (identical) databases