MatthewYoung
Programmer
Using JDBC to insert records into an XML enabled DB2 database with the following SQL:
INSERT INTO RESURS (RESURSTYP,BETECKNING,ALIAS,FROMTSTAMP,TOMTSTAMP,S KAPADID,SKAPADTSTAMP,TSTAMP,XMLDATA) VALUES ('miljö',?,null,?,null,null,current timestamp,current timestamp,DB2XML.XMLVarchar(cast (? as VARCHAR(1000))));
Want to alter the encoding from UTF-8 to ISO-8859-1 but unsure how this is done. The XMLVarcharFromFile function has an encoding parameter but the XML Extender manuals don't seem to cover the case of PreparedStatements setting XML data from a variable with a specific encoding.
INSERT INTO RESURS (RESURSTYP,BETECKNING,ALIAS,FROMTSTAMP,TOMTSTAMP,S KAPADID,SKAPADTSTAMP,TSTAMP,XMLDATA) VALUES ('miljö',?,null,?,null,null,current timestamp,current timestamp,DB2XML.XMLVarchar(cast (? as VARCHAR(1000))));
Want to alter the encoding from UTF-8 to ISO-8859-1 but unsure how this is done. The XMLVarcharFromFile function has an encoding parameter but the XML Extender manuals don't seem to cover the case of PreparedStatements setting XML data from a variable with a specific encoding.