in reply to Mysterious null-padding

I have no deep insight on DBD::ODBC, but maybe you can use the ->bind_param method of DBI to tell DBI to keep the data as-is instead of trying to convert the data to some other encoding.

Replies are listed 'Best First'.
Re^2: Mysterious null-padding
by belg4mit (Prior) on Jan 28, 2016 at 15:40 UTC
    We have a winner! As mje was able to confirm, MicroSoft is not <drumRoll/> fully standards compliant, and is massaging the data because it assumes it's a VARCHAR.

    --
    In Bob We Trust, All Others Bring Data.