in client-adapter/tablestore/src/main/java/com/alibaba/otter/canal/client/adapter/tablestore/support/SyncUtil.java [168:201]
public static TablestoreFieldType getDefaultTablestoreType(int sqlType) {
switch (sqlType) {
case Types.BIT:
case Types.BOOLEAN:
return TablestoreFieldType.BOOL;
case Types.BINARY:
case Types.VARBINARY:
case Types.LONGVARBINARY:
case Types.BLOB:
return TablestoreFieldType.BINARY;
case Types.TINYINT:
case Types.SMALLINT:
case Types.INTEGER:
case Types.BIGINT:
return TablestoreFieldType.INT;
case Types.DECIMAL:
case Types.NUMERIC:
case Types.REAL:
case Types.FLOAT:
case Types.DOUBLE:
return TablestoreFieldType.DOUBLE;
case Types.CHAR:
case Types.NCHAR:
case Types.VARCHAR:
case Types.LONGVARCHAR:
case Types.CLOB:
case Types.DATE:
case Types.TIME:
case Types.TIMESTAMP:
return TablestoreFieldType.STRING;
default:
return TablestoreFieldType.STRING;
}
}