XMLTYPE
The XMLTYPE data type, available from MariaDB 12.3, for storing XML data.
Introduced
MariaDB 12.3
Syntax
XMLTYPENo parameters accepted
Length specification for
XMLTYPE(e.g.,XMLTYPE(100)) results in an error
Description
XMLTYPE is a data type introduced in MariaDB 12.3 for storing XML data. It is designed to:
Provide convenient storage of XML data
Ensure compatibility with Oracle databases
Support future XML validation and processing capabilities
In its initial implementation, XMLTYPE provides basic XML storage capabilities only, without validation or specialized XML-specific functionality. When using string functions, the data type is effectively converted to strings and is maintained in temporary tables.
Characteristics
Maximum storage capacity: 4GB (same as
LONGBLOB)Compatibility: Designed to be compatible with Oracle’s
XMLTYPEValidation: XML validation or schema enforcement is not supported
Length restriction: Length cannot be specified.
Example (invalid usage):
XMLTYPE does not accept length parameters, unlike data types such as VARCHAR(255) or DECIMAL(10,2).
Related Functions
With MariaDB 12.3, the following functions return the XMLTYPE data type:
UPDATEXMLCAST
Examples
Basic Tables Creation
Output
Character Set Specification
Output
Binary Attribute
Output
Basic Data Insertion and Selection
Output
Restrictions and Error Cases
Length Specification Not Permitted
If a length parameter is provided for XMLTYPE, the system returns an error:
Output
REF_SYSTEM_ID Attribute Not Supported
Output
Length Parameters in Complex Column Definitions
Output
See Also
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?

