Re: Text field truncation problem - Mailing list pgsql-odbc

From Graham Vickrage
Subject Re: Text field truncation problem
Date
Msg-id 001701c2924a$1805be60$6d00000a@GVICKRAGE
Whole thread Raw
In response to Re: Text field truncation problem  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List pgsql-odbc
So should all the data types be 50+1 bytes, I don't know much about this
sort of thing and really need to get this going. Are there any docs,
resources anyone knows about where I can try and locate the issue. Is it
likely to be a driver problem, postgreSQL, NT problem. Where do I
start????

Please heeeeeeeeeeeeeeeelp.

Thanks again

Graham

-----Original Message-----
From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
Sent: 22 November 2002 00:14
To: Graham Vickrage
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Text field truncation problem


Graham Vickrage wrote:
>
> I am trying to sort out a problem with ODBC truncating text fields.
>
> I am running Postgres 7.2.3, and using the latest ODBC driver from the

> official website.
>
> When I connect through the windows client I get the message:
>
> Test2.pl: DBD::ODBC::st fetchrow_hashref failed: Fetched item was
> truncated. (SQL-01004)(DBD: st_fetch/SQLFetch (long truncated) err=1)
>
> I have attached the log from the ODBC if that is any use.

Judging from the log, your program is binding a (80+1) byte buffer for
the "description" text field. I don't understand where the 80(or 81)
come from. OTOH your program seems to be binding the "name" field with a
right(50+1 byte) sized buffer.

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




pgsql-odbc by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: Re: Very large queries with ODBC
Next
From: "Graham Vickrage"
Date:
Subject: Re: Text field truncation problem