Baidu AI Cloud DTS Data Type
Last Updated：2020-09-01
Data Types of Baidu AI Cloud DTS
Baidu AI Cloud DTS uses built-in data types to migrate data from one database engine type to another. The following table shows the built-in data types and their descriptions.
| DTS field type | Specific description |
|---|---|
| DTS_TYPE_BYTES | Binary data value (byte string), character set cannot be set |
| DTS_TYPE_STRING | String, character set can be set |
| DTS_TYPE_BOOLEAN | Boolean value |
| DTS_TYPE_DATE | Date value: Month, day, year |
| DTS_TYPE_TIME | Time value : hour, minute, second |
| DTS_TYPE_DATETIME (fraction) | Timestamp value: year, month, day, hour, minute, second, fractional second. Fractional seconds with up to 9 digits |
| DTS_TYPE_NUMBER | Precise numeric value with fixed precision and decimal places |
| DTS_TYPE_INT1 | Signed 1-byte integer |
| DTS_TYPE_INT2 | Signed 2-byte integer |
| DTS_TYPE_INT4 | Signed 4-byte integer |
| DTS_TYPE_INT8 | Signed 8-byte integer |
| DTS_TYPE_FLOAT | Single precision floating point |
| DTS_TYPE_DOUBLE | Double precision floating point |