Message-ID: <gh-postgresql-interfaces-psqlodbc-98-c3066027566@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Sat, 12 Jul 2025 20:27:12 +0000
Subject: Re: [postgresql-interfaces/psqlodbc] issue #98: SELECT of a PostgreSQL CHAR/VARCHAR/TEXT Column Using multiple calls SQLGetData results in data truncation (last byte)
In-Reply-To: <gh-postgresql-interfaces-psqlodbc-98@github.com>
References: <gh-postgresql-interfaces-psqlodbc-98@github.com>
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 3066027566
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 98
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/98#issuecomment-3066027566
Content-Type: text/plain; charset=utf-8

Please use the latest driver.


Dave Cramer


On Tue, 8 Jul 2025 at 02:48, Spark098 ***@***.***> wrote:

> *Spark098* left a comment (postgresql-interfaces/psqlodbc#98)
> <https://github.com/postgresql-interfaces/psqlodbc/issues/98#issuecomment-3047585425>
>
> Hello @davecramer <https://github.com/davecramer>
>
> Can you please try with the shortened test case (as mentioned in the
> thread before) when we are using buffer of size 10 and inserting data of
> size 12 bytes of data in the TEXT column.
> I could reproduce the issue.
> Native driver version is 16.00.0000
>
> standalone output:
>
> Connecting to database.
> Connected to database.
> Fetching results...
> First Call to GetData:
> ind : 12
> Data: AAAAAAAAAA
> Second Call to GetData:
> ind : 2
> Data: B
> Free handles.
> postgres=# select * from rantexttab;
> textcol
>
> AAAAAAAAAABB
> (1 row)
>
> —
> Reply to this email directly, view it on GitHub
> <https://github.com/postgresql-interfaces/psqlodbc/issues/98#issuecomment-3047585425>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AADDH5TZWI7H75C7277ZHB33HNSTNAVCNFSM6AAAAABZHG6QMSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTANBXGU4DKNBSGU>
> .
> You are receiving this because you were mentioned.Message ID:
> ***@***.***>
>