Message-ID: <gh-postgresql-interfaces-psqlodbc-98-c3047585425@github.com>
From: "Spark098 (@Spark098)" <noreply+Spark098@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Tue, 08 Jul 2025 06:48:01 +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: Spark098
X-GitHub-Comment-Id: 3047585425
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-3047585425
Content-Type: text/plain; charset=utf-8

Hello @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)