| From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | Graham Vickrage <graham(at)gpmd(dot)co(dot)uk> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Text field truncation problem |
| Date: | 2002-11-22 00:13:34 |
| Message-ID: | 3DDD76AE.410DC53E@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joan Picanyol i Puig | 2002-11-22 00:33:25 | Re: insert into view with a defined rule fails from MSAccess |
| Previous Message | Hiroshi Inoue | 2002-11-22 00:06:04 | Re: empty text on XP in MS Access |