Random Characters Appearing after Data
Posted: 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
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