Re: [INTERFACES] Invalid BLOB Length - Mailing list pgsql-interfaces

From Byron Nikolaidis
Subject Re: [INTERFACES] Invalid BLOB Length
Date
Msg-id 36F8F83D.FD11A728@insightdist.com
Whole thread Raw
In response to Invalid BLOB Length  (PostgreSQL Server <postgres@www.Mythos.Org>)
List pgsql-interfaces

PostgreSQL Server wrote:

> I am using Borland C++ Builder 3.0 with PostgreSQL 6.4.2 and the
> latest ODBC driver from ftp.postgresql.org.
>
> I created a table users that looks like this:
>
> CREATE TYPE lo (
>         internallength = 4,
>         externallenght = 10,
>         input = int4in,
>         output = int4out,
>         send = int4out,
>         receive = int4in,
>         default = '',
>         passedbyvalue);
>
> CREATE TABLE users (
>         userid int4,
>         username varchar(255),
>         userimage lo);
>
> When I try and insert an image, the app returns "Invalid BLOB Length".
>
> What am I doing Wrong?
>
> Thanks
>
>                 Travis


Are there any errors in the driver's commlog ("psqlodbc.log") file?  You
can also check the odbc trace log.  If you can't figure anything out, you
can try sending me the logs and I could take a look.

Byron



pgsql-interfaces by date:

Previous
From: Eric Marsden
Date:
Subject: [ANN] pg.el -- Emacs Lisp interface for PostgreSQL
Next
From: Byron Nikolaidis
Date:
Subject: Re: [INTERFACES] why there's only char type?