XML Type Ordering | Teradata Vantage - XML Type Cast - Advanced SQL Engine - Teradata Database

XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
amr1556233250442.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1140
lifecycle
previous
Product Category
Teradata Vantageā„¢

When casting to XML type from other SQL types, an XML value of the nearest xml schema primitive type is created. For example, xs:string for VARCHAR/CLOB and xs:date for DATE.

When casting from XML type to other SQL types, the string value of the XML instance should be compatible with the target data type. For example, xs:date value being cast to SQL DATE type.

Casts to and from XML type are supported for the following data types.
  • VARCHAR
  • CLOB
  • VARBYTE
  • BLOB
  • BYTEINT
  • SMALLINT
  • INTEGER
  • BIGINT
  • DECIMAL
  • FLOAT
  • NUMBER
  • DATE
  • TIME
  • TIME WITH TIMEZONE
  • TIMESTAMP
  • TIMESTAMP WITH TIMEZONE
  • INTERVAL YEAR
  • INTERVAL YEAR TO MONTH
  • INTERVAL MONTH
  • INTERVAL DAY
  • INTERVAL DAY TO HOUR
  • INTERVAL DAY TO MINUTE
  • INTERVAL DAY TO SECOND
  • INTERVAL HOUR
  • INTERVAL HOUR TO MINUTE
  • INTERVAL HOUR TO SECOND
  • INTERVAL MINUTE
  • INTERVAL MINUTE TO SECOND
  • INTERVAL SECOND
Casting to XML type from large object types (CLOB and BLOB) is subject to a limitation that only values up to 64KB in size can be cast successfully.

When casting from XML type to VARCHAR or CLOB, only the UNICODE character set is supported for the target data type.

When casting to XML type, you can specify the inline length so that the resulting XML data type can be a LOB type or a non-LOB type.