Fix getXXX methods when used with CHAR columns or columns with decimals

Problem:
 - Error parsing input in getByte() and getShort() if input has a decimal or whitespace (from CHAR columns)
 - Error parsing CHAR columns in other getXXX methods.

Fix:
 - Added trim() to getXXX methods
 - In getByte() and getShort(), check the field type and take out the decimal and everything after it. Also check for
CHARand trim if necessary. 

Cheers,

Kim