Supported Datatypes for Conversion Transformations
Metadata Insights supports the datatypes mentioned in the table below while applying conversion transformations.
| Type | Description |
|---|---|
| String or Varchar | Variable length character string with a maximum length of 4000 |
| Varbinary | Variable length binary string with a nominal maximum length of 8192 |
| Char | A single Unicode character |
| Boolean | A single bit, or Boolean, with two possible values |
| Byte or Tinyint | Numeric, integral type, signed 8-bit |
| Short or Smallint | Numeric, integral type, signed 16-bit |
| Integer or Serial | Numeric, integral type, signed 32-bit. The serial type also implies not null and has an auto-incrementing value that starts at 1. Serial types are not automatically UNIQUE. |
| Long or Bigint | Numeric, integral type, signed 64-bit |
| Biginteger | Numeric, integral type, arbitrary precision of up to 1000 digits |
| Float or Real | Numeric, floating point type, 32-bit IEEE 754 floating-point numbers |
| Double | Numeric, floating point type, 64-bit IEEE 754 floating-point numbers |
| Bigdecimal or Decimal | Numeric, floating point type, arbitrary precision of up to 1000 digits |
| Date | Datetime, representing a single day (year, month, day) |
| Time | Datetime, representing a single time (hours, minutes, seconds, milliseconds) |
| Timestamp | Datetime, representing a single date and time (year, month, day, hours, minutes, seconds, milliseconds, nanoseconds) |