/**
* Guesses at the standard type that corresponds to the given name. Returns null if no known
* corresponding type.
*/
public static StandardType standardType(String name) {
if (name == null) {
return null;
}
if (name.equalsIgnoreCase("INT")) {
name = "INTEGER";
}
if (name.equalsIgnoreCase("DATETIME")) {
name = "TIMESTAMP";
}
if (name.equalsIgnoreCase("DATETIME WITH TIMEZONE")) {
name = "TIMESTAMPZ";
}
if (name.equalsIgnoreCase("TIME WITH TIMEZONE")) {
name = "TIMEZ";
}
try {
return StandardType.valueOf(name.toUpperCase());
} catch (IllegalArgumentException e) {
return null;
}
}
