XML is a markup language; therefore, data or text is marked up with tags that represent metadata that makes the XML self-describing. The universally recognized XML markup scheme is text-based.
Teradata drivers support a text-based format for XML values. A client application or driver that uses the text format might require access to an XML parser to be able to parse the XML received on the wire.
The text format returns the XML serialization of the XML value. XML values retrieved in the text format are encoded in UTF-8. The following shows an example of document retrieval.
<?xml version="1.0" encoding="UTF-8"?>
<customer>
<Name>John Hancock</Name>
<Address>100 1st Street One City, CA 12345</Address>
<Phone1>(999)9999-999</Phone1>
<Phone2>(999)9999-998</Phone2>
<Fax>(999)9999-997</Fax>
<Email>John@somecompany.com</Email>
<order Number="NW-01-16366" Date="Feb/28/2001">
<Contact>Mary Shannon</Contact>
<Phone>(987)6543-210</Phone>
<ShipTo>Widgets Inc., 123 Regency Parkway, Portland, OR 43211</ShipTo>
<SubTotal>2355.00</SubTotal>
<Tax>141.50</Tax>
<Total>2496.50</Total>
<item ID="001">
<Quantity>100</Quantity>
<PartNumber>F54709</PartNumber>
<Description/>
<UnitPrice>23.55</UnitPrice>
<Price>2355.00</Price>
</item>
</order>
</customer>
For the text format, the server will not try to pretty-print the XML value when serializing it for transfer to the client. If the client application needs to display the XML, it is up to the application to decide whether to do pretty-printing, provide syntax-highlighting, or other display options.