originalDatatype = vals[1];
if(mappingColumn!=null) newDatatype = mappingColumn.getAttributeValue("new-type");
if(newDatatype==null) {
- if("LONGBLOB".equals(originalDatatype.toUpperCase())) newDatatype="BLOB";
+ String upperOrginialType = originalDatatype.toUpperCase();
+ if("LONGBLOB".equals(upperOrginialType)) newDatatype="BLOB";
+ else if("INTEGER".equals(upperOrginialType) || "DECIMAL".equals(upperOrginialType)) {
+ newDatatype="NUMBER";
+ }
else {
newDatatype = originalDatatype;
if(newDatatype.startsWith("VARCHAR")) {