Global Types to Oracle Data Types
The initiator connector maps global data types to Teradata data types.
| Global Data Type | Oracle Data Type |
|---|---|
| G_Array | Varchar (Character Set Unicode) |
| G_Array_VC_UTF16 / G_Array_VC_Latin | Array |
| G_Bigint | Bigint |
| G_Blob | Blob |
| G_Boolean | Byteint |
| G_Byte | Byte |
| G_ByteInt | Byteint |
| G_Char_Latin / G_Char_UTF16 | Char (Character Set Latin / Unicode) |
| G_Clob_UTF16 / G_Clob_Latin | Clob |
| G_Date | Date |
| G_Decimal | Decimal |
| G_Double | Double precision |
| G_Float | Float |
| G_Integer | Integer |
| G_IntervalDayToSecond | Interval day to second |
| G_IntervalYearToMonth | Interval year to month |
| G_JSON_UTF16 / G_JSON | NVarchar2 |
| G_Number | Number |
| G_SmallInt | Smallint |
| G_Time | Time |
| G_Timestamp | Timestamp |
| G_TimestampWithTimeZone | Timestamp with time zone |
| G_TimeWithTimeZone | Time with time zone |
| G_Varbyte | Long raw |
| G_Varchar_Latin | Varchar (Character Set Latin) |
| G_Varchar_UTF16 | NVarchar2 (Character Set Unicode) |
| G_XML | NVarchar2 |
| Others | Varchar2 |
Oracle Data Types to Global Types
The target connector maps Teradata data types to global data types.
| Oracle Data Type | Global Data Type |
|---|---|
| Binary_Double | G_Double |
| Binary_Float | G_Float |
| Blob | G_Blob |
| Char | G_Char_UTF16 / G_Char_Latin (based on charset) |
| Clob | G_Clob_UTF16 |
| Date | G_Date |
| IntervalDS | G_IntervalDayToSecond |
| IntervalYM | G_IntervalYearToMonth |
| Long | G_Clob_UTF16 |
| Long raw | G_Blob |
| NChar | G_Char_UTF16 |
| NClob | G_Clob_UTF16 |
| Number | G_Number |
| NVarchar | G_Varchar_UTF16 |
| RAW | G_Byte |
| Timestamp | G_TimeStamp |
| Timestamp with local time zone | G_TimeStamp |
| Timestamp with time zone | G_TimestampWithTimeZone |
| Varchar2 / Varchar | G_Varchar_UTF16 / G_Varchar_Latin (based on charset) |
| Varray | G_Array User must have access to SELECT_CATALOG_ROLE.
|
| Others | Currently not supported |