Pad CHAR types automatically #348

@jtaylor-sfdc i have added the tests, let me know if more test scenario's are needed