[jboss-jira] [JBoss JIRA] Closed: (BPEL-261) use varbinary instead of varchar as data type to store dom elements

use varbinary instead of varchar as data type to store dom elements ------------------------------------------------------------------- Key: BPEL-261 URL: http://jira.jboss.com/jira/browse/BPEL-261 Project: JBoss jBPM BPEL Issue Type: Task Security Level: Public(Everyone can see) Components: Engine Reporter: Alejandro Guizar Assigned To: Alejandro Guizar Fix For: jBPM BPEL 1.1 GA The documentation for javax.xml.transform.stream.StreamResult {http://java.sun.com/j2se/1.4.2/docs/api/javax/xml/transform/stream/StreamResult.html} reads: Normally, a stream should be used rather than a [writer], so that the transformer may use instructions contained in the transformation instructions to control the encoding. It turns out byte streams are preferred over character streams. In consequence, the data type used to store dom elements in the database should be varbinary rather than varchar. Plus, the byte stream output lends itself better to compression.