changed some fields from String to CHAR to better match datatype in the
database