Supported and Unsupported Mappings from RDMS to Kafka table lists if a mapping from a source RDMS data type to a target XSD data type is supported, unsupported, or results in an error, warning, or may have warning.
For more information about the data type mapping compatibility, refer to Interpreting Mapping Compatibility between Data Types.
Table 19. Supported and Unsupported Mappings from RDMS to Kafka
| RDMS Data Types | XSD Data Types | ||||
|---|---|---|---|---|---|
| Supported | Unsupported | Error | Warning | May Have Warning | |
Character | Boolean | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Double, gYear, gMonth, gDay, string, Qname, normalizedString, Token, ID, IDREF, ENTITY, Name, NMTOKEN, NCName | anyURI, Language |
Character with UCS-2 | Boolean | Duration, NOTATION, Base64Binary, HexBinary | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Double, date, datetime, gYearMonth, gMonthDay, time, anyURI, Language | gYear, gMonth, gDay | string, Qname, normalizedString, Token, ID, IDREF, ENTITY, Name, NMTOKEN, NCName |
Ncharacter | Boolean | Duration, NOTATION, Base64Binary, HexBinary | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Double, date, datetime, gYearMonth, gMonthDay, time, gYear, gMonth, gDay, anyURI, Language | Nil | string, Qname, normalizedString, Token, ID, IDREF, ENTITY, Name, NMTOKEN, NCName |
Decimal | Float, Boolean, Double | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, gYear, gMonth, gDay | Long, Int, Short, Byte, Integer, Decimal, string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Numeric | Float, Boolean, Double | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, gYear, gMonth, gDay | Long, Int, Short, Byte, Integer, Decimal, string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Integer | Integer, Long, Int, Float, Boolean, Double | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, gYear, gMonth, gDay | Decimal, string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
SmallInt | Integer, Long, Int, Float, Boolean, Double | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, gYear, gMonth, gDay | Decimal, string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Real | Float, Boolean, Double | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, gYear, gMonth, gDay | string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Float | Float, Boolean, Double | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, gYear, gMonth, gDay | string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Double | Float, Boolean, Double | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, gYear, gMonth, gDay | string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Date | Boolean, date, datetime, gYearMonth, gMonthDay, gYear, gMonth, gDay | Duration, NOTATION, Base64Binary, HexBinary | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Double, time, ID, IDREF, ENTITY, Name, NCName | Nil | string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Time | Boolean, datetime, time | Duration, NOTATION, Base64Binary, HexBinary | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Double, date, gYearMonth, gMonthDay, gYear, gMonth, gDay, ID, IDREF, ENTITY, Name, NCName | Nil | string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
TimeStamp | Boolean, date, datetime, gYearMonth, gMonthDay, time, gYear, gMonth, gDay | Duration, NOTATION, Base64Binary, HexBinary | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Double, ID, IDREF, ENTITY, Name, NCName | Nil | string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
| BLOB | Nil | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Boolean, Double, date, datetime, Duration, gYearMonth, gMonthDay, time, gYear, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN, ID, IDREF, ENTITY, Name, NCName, NOTATION, Base64Binary, HexBinary | Nil | Nil | Nil |
| 9-bit Character | Nil | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Boolean, Double, date, datetime, Duration, gYearMonth, gMonthDay, time, gYear, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN, ID, IDREF, ENTITY, Name, NCName, NOTATION, Base64Binary, HexBinary | Nil | Nil | Nil |