@Override
public DatabaseDataType toDatabaseDataType(Database database) {
String originalDefinition = StringUtils.trimToEmpty(getRawDefinition());
if (database instanceof H2Database || database instanceof HsqlDatabase) {
if (originalDefinition.toLowerCase().startsWith("longvarbinary")
|| originalDefinition.startsWith("java.sql.Types.LONGVARBINARY")) {
return new DatabaseDataType("LONGVARBINARY");
} else if (originalDefinition.toLowerCase().startsWith("binary")) {
return new DatabaseDataType("BINARY", getParameters());
} else {
return new DatabaseDataType("BLOB");
}
}
if (database instanceof MSSQLDatabase) {
Object[] parameters = getParameters();
if (originalDefinition.equalsIgnoreCase("varbinary")
|| originalDefinition.equals("[varbinary]")
|| originalDefinition.matches("(?i)varbinary\\s*\\(.+")
|| originalDefinition.matches("\\[varbinary\\]\\s*\\(.+")) {
if (parameters.length < 1) {
parameters = new Object[] {1};
} else if (parameters.length > 1) {
parameters = Arrays.copyOfRange(parameters, 0, 1);
}
return new DatabaseDataType(database.escapeDataTypeName("varbinary"), parameters);
}
if (originalDefinition.equalsIgnoreCase("binary")
|| originalDefinition.equals("[binary]")
|| originalDefinition.matches("(?i)binary\\s*\\(.+")
|| originalDefinition.matches("\\[binary\\]\\s*\\(.+")) {
if (parameters.length < 1) {
parameters = new Object[] {1};
} else if (parameters.length > 1) {
parameters = Arrays.copyOfRange(parameters, 0, 1);
}
return new DatabaseDataType(database.escapeDataTypeName("binary"), parameters);
}
if (originalDefinition.equalsIgnoreCase("image") || originalDefinition.equals("[image]")) {
return new DatabaseDataType(database.escapeDataTypeName("image"));
}
boolean max = true;
if (parameters.length > 0) {
String param1 = parameters[0].toString();
max =
!param1.matches("\\d+")
|| new BigInteger(param1).compareTo(BigInteger.valueOf(8000L)) > 0;
}
if (max) {
try {
if (database.getDatabaseMajorVersion() <= 8) { // 2000 or earlier
return new DatabaseDataType(database.escapeDataTypeName("image"));
}
} catch (DatabaseException ignore) {
} // assuming it is a newer version
return new DatabaseDataType(database.escapeDataTypeName("varbinary"), "MAX");
}
if (parameters.length > 1) {
parameters = Arrays.copyOfRange(parameters, 0, 1);
}
return new DatabaseDataType(database.escapeDataTypeName("varbinary"), parameters);
}
if (database instanceof MySQLDatabase) {
if (originalDefinition.toLowerCase().startsWith("blob")
|| originalDefinition.equals("java.sql.Types.BLOB")) {
return new DatabaseDataType("BLOB");
} else if (originalDefinition.toLowerCase().startsWith("varbinary")
|| originalDefinition.equals("java.sql.Types.VARBINARY")) {
return new DatabaseDataType("VARBINARY", getParameters());
} else if (originalDefinition.toLowerCase().startsWith("tinyblob")) {
return new DatabaseDataType("TINYBLOB");
} else if (originalDefinition.toLowerCase().startsWith("mediumblob")) {
return new DatabaseDataType("MEDIUMBLOB");
} else if (originalDefinition.toLowerCase().startsWith("binary")) {
return new DatabaseDataType("BINARY", getParameters());
} else {
return new DatabaseDataType("LONGBLOB");
}
}
if (database instanceof PostgresDatabase) {
return new DatabaseDataType("BYTEA");
}
if (database instanceof SybaseASADatabase) {
return new DatabaseDataType("LONG BINARY");
}
if (database instanceof SybaseDatabase) {
return new DatabaseDataType("IMAGE");
}
if (database instanceof OracleDatabase) {
if (getRawDefinition().toLowerCase().startsWith("bfile")) {
return new DatabaseDataType("BFILE");
}
return new DatabaseDataType("BLOB");
}
if (database instanceof FirebirdDatabase) {
return new DatabaseDataType("BLOB");
}
return super.toDatabaseDataType(database);
}
