Tipos globales a tipos de datos de Teradata
El conector de iniciador asigna tipos de datos globales a tipos de datos de Teradata.
Los tipos de datos de Teradata marcados con un asterisco (*) solo están disponibles con Teradata Database 16.20 Feature Update 1 y versiones posteriores.
Tipo de datos globales | Tipo de datos de Teradata |
---|---|
G_Array | Varchar (conjunto de caracteres 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_Kanji1 | Char (conjunto de caracteres Kanji1) |
G_Char_KanjiSJIS | Char (conjunto de caracteres KanjiSJIS) |
G_Char_Latin | Char (conjunto de caracteres Latino) |
G_Char_UTF8 | Char (conjunto de caracteres Unicode) |
G_Char_UTF16 | Char (conjunto de caracteres Unicode) |
G_Clob_UTF16/G_Clob_Latin | Clob |
G_DatasetAvro | Dataset storage format Avro * |
G_Date | Date |
G_Decimal/G_BigDecimal | Decimal |
G_Double | Double precision |
G_Float | Float |
G_Integer | Integer |
G_IntervalDay | Interval day |
G_IntervalDayToHour | Interval day to hour |
G_IntervalDayToMinute | Interval day to minute |
G_IntervalDayToSecond | Interval day to second |
G_IntervalHour | Interval hour |
G_IntervalHourToMinute | Interval hour to minute |
G_IntervalHourToSecond | Interval hour to second |
G_IntervalMinute | Interval minute |
G_IntervalMinuteToSecond | Interval minute to second |
G_IntervalMonth | Interval month |
G_IntervalSecond | Interval second |
G_IntervalYear | Interval year |
G_IntervalYearToMonth | Interval year to month |
G_JSON_UTF16/G_JSON_Latin | JSON * |
G_Map | Varchar (conjunto de caracteres Unicode) |
G_MBB | MBB * |
G_MBR | MBR * |
G_Number | Number |
G_Period | Period * |
G_Row | Varchar (conjunto de caracteres Unicode) |
G_SmallInt | Smallint |
G_STGeometry | ST_Geometry * |
G_Time | Time |
G_TimeWithTimeZone | Time with time zone |
G_Timestamp | Timestamp |
G_TimestampWithTimeZone | Timestamp with time zone |
G_UDT_UTF16/G_UDT_Latin | UDT diferenciado/UDT estructurado * |
G_Varbyte | Varbyte |
G_Varchar_Kanji1 | Varchar (conjunto de caracteres Kanji1) |
G_Varchar_KanjiSJIS | Varchar (conjunto de caracteres KanjiSJIS) |
G_Varchar_Latin | Varchar (conjunto de caracteres Latino) |
G_Varchar_UTF8 | Varchar (conjunto de caracteres Unicode) |
G_Varchar_UTF16 | Varchar (conjunto de caracteres Unicode) |
G_XML | XML * |
Otros | No se admite actualmente |
Tipos de datos de Teradata a tipos globales
El conector de destino asigna tipos de datos de Teradata a tipos de datos globales.
Los tipos de datos de Teradata marcados con un asterisco (*) solo están disponibles con Teradata Database 16.20 Feature Update 1 y versiones posteriores.
Tipo de datos de Teradata | Tipo de datos globales |
---|---|
Array * | G_Array_VC_UTF16/G_Array_VC_Latin |
Bigint | G_BigInt |
Blob | G_Blob |
Byte | G_Byte |
Byteint | G_Byteint |
Char | G_Char_UTF16/G_Char_Latin/G_Char_Kanji1/G_Char_KanjiSJIS |
Clob | G_Clob_UTF16/Latin |
Dataset storage format Avro * | G_DatasetAvro |
Date | G_Date |
Decimal | G_Decimal |
Distinct UDT/Structured UDT * | G_UDT/G_UDT_UTF16/G_UDT_Latin |
Double precision | G_Double |
Float | G_Float |
Integer | G_Integer |
Interval day | G_IntervalDay |
Interval day to hour | G_IntervalDayToHour |
Interval day to minute | G_IntervalDayToMinute |
Interval day to second | G_IntervalDayToSecond |
Interval hour | G_IntervalHour |
Interval hour to minute | G_IntervalHourToMinute |
Interval hour to second | G_IntervalHourToSecond |
Interval minute | G_IntervalMinute |
Interval minute to second | G_IntervalMinuteToSecond |
Interval month | G_IntervalMonth |
Interval second | G_IntervalSecond |
JSON * | G_JSON_UTF16/G_JSON_Latin |
MBB * | G_MBB |
MBR * | G_MBR |
Number | G_Number |
Period (todos los tipos) * | G_Period |
Smallint | G_SmallInt |
ST_Geometry * | G_STGeometry |
Timestamp | G_TimeStamp |
Timestamp with time zone | G_TimestampWithTimeZone |
Varbyte | G_Varbyte |
Varchar | G_Varchar_UTF16/G_Varchar_Latin/G_Varchar_Kanji1/G_Varchar_KanjiSJIS |
XML * | G_XML |
Otros | No se admite actualmente |