skip to main content
DataDirect Connect Drivers : PostgreSQL Driver : Returning and Inserting/Updating XML Data : Returning XML Data
  
Returning XML Data
The driver returns XML data as character data. Your application can use the following methods to return data stored in XML columns as character data:
*ResultSet.getString()
*ResultSet.getCharacterStream()
*ResultSet.getClob()
*CallableStatement.getString()
*CallableStatement.getClob()
The driver converts the XML data returned from the database server from the UTF-8 encoding used by the database server to the UTF-16 Java String encoding.
Your application can use the following method to return data stored in XML columns as ASCII data:
*ResultSet.getAsciiStream()
The driver converts the XML data returned from the database server from the UTF-8 encoding to the ISO-8859-1 (latin1) encoding.
Note: The conversion caused by using the getAsciiStream() method may create XML that is not well-formed because the content encoding is not the default encoding and does not contain an XML declaration specifying the content encoding. Do not use the getAsciiStream() method if your application requires well-formed XML.