On 7/26/2017 7:25 PM, Igor Korot wrote:
When I tried to query the database table with the column "char(129)" I get:

"My field text"

(the text with the bunch of spaces at the end).

The driver is not the current one - but I don't remember the version.

Is this known issue? Maybe its already fixed with the latest ODBC driver?

a char(129) field is 129 characters long, and will always be padded with spaces to that length.

maybe you wanted a varchar (aka char varying) ? these are variable length and return just what you put in them.


--
john r pierce, recycling bits in santa cruz



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to