Hi All, Here is the scenario I encountered this problem of wrong result.
----------------------------------------------------------------------------------------------------------------------------------- ij> connect 'jdbc:derby:memory:dummy;create=true'; ij> create table t ( a xml ); 0 rows inserted/updated/deleted ij> insert into t ( a ) values ( xmlparse( document '<?xml version="1.0" encodin g="UTF-8"?> <!DOCTYPE xsl:stylesheet [<!ENTITY nbsp " ">]> <?xml-stylesheet href="z_files/global.css" type="text/css"?> <html id="feedHandler" xmlns="http: //www.w3.org/1999/xhtml" xmlns:xul="http://www.mozilla.org/keymaster/gatekeeper /there.is.only.xul"> <head> <meta http-equiv="content-type" content="text/html ; charset=UTF-8" /> <title>Derby 10.6.1 Fixed Bugs List (ASF JIRA)</title> <link rel="stylesheet" href="z_files/subscribe.css" type="text/css" media="a ll" /> <script type="application/x-javascript" src="z_files/subscribe.js"></ script> </head></html>' preserve whitespace ) ); 1 row inserted/updated/deleted ij> select xmlserialize(a as clob) from t; -------------------------------------------------------------------------------- ------------------------------------------------ <?xml-stylesheet href="z_files/global.css" type="text/css"?><html xmlns="http:// www.w3.org/1999/xhtml" xmlns:xul="http://www.mo&; 1 row selected ----------------------------------------------------------------------------------------------------------------------- Why is the result not complete? or Did I make any mistake here? Thanks. -- Best Regards, Nirmal C.S.Nirmal J. Fernando Department of Computer Science & Engineering, Faculty of Engineering, University of Moratuwa, Sri Lanka.
