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