f length of field "FilesTransfered" is more than 255 characters, its truncated.

Sure, but not on retrieval. It means you're trying to stuff more than 255 characters in a field that doesn't allow more. It's like putting 100 pairs of socks in a drawer that only fits 20. You cannot get more than 20 pairs of socks out of them, the other 80 will have dropped on the ground.

Change the type of column, and repopulate the table.

Note that this isn't a Perl issue. It's a database issue, and you'll have this problem regardless of the language you're using to access the database.