Random Characters Appearing after Data

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
PCh
Posts: 1
Joined: Mon 19 Oct 2020 00:57

Random Characters Appearing after Data

Post by PCh » Mon 19 Oct 2020 02:54

Hello,

I am using Devart ODBC Driver for PostgreSQL (server license, version 3.3.4.) to connect from SSMS to PostgreSQL. When I execute my query directly in pgAdmin I get the expected results. However when I run my query in SSMS using the ODBC driver, two additional characters or symbols are being added to the end of my expected results.

For example, in pgAdmin I get: Testing. END.

But in SSMS I get: Testing. END.es

Each time I execute my query in SSMS (without changing my query) the additional characters will change, or occasionally won't be present at all.

I have been able to find a work around by selecting the length of my field and incorporating that into a substring:
SELECT substring(myfield,1,(length(myfield))) FROM mytable

Thanks

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: Random Characters Appearing after Data

Post by oleg0k » Thu 22 Oct 2020 08:19

Hello,
Unfortunately, we couldn't reproduce the issue. Please specify the exact version of your PostgreSQL server and send us the DDL script for creating and populating tables used in your example. We also need the query that you're trying to run in SSMS.
Please send them through the form on our website: https://devart.com/company/contactform.html

wbr, Oleg
Devart Team

Post Reply