Re: ExtractXML in MySQL 5.1.5 returns BLOB. I need VARCHAR.
CREATE TABLE `complaints` (`ComplaintSub_Category` varchar(100) NOT NULL default '',`ComplaintID` varchar(100) NOT NULL,
`Complaint_Raise_Date` timestamp NOT NULL default CURRENT_TIMESTAMP, `Complaint_Description` varchar(512) default NULL,
`Assigned_to` varchar(100) NOT NULL default '', `Complaint_Status` varchar(100) default NULL,`Complaint_Close_Date` timestamp NULL default NULL,
`Division` varchar(100) NOT NULL, `Sub_Division` varchar(100) NOT NULL default '', `Service_Station` varchar(100) NOT NULL default '',
`ComplaintType` varchar(100) NOT NULL, PRIMARY KEY (`ComplaintID`))
<?xml version="1.0" encoding="UTF-8"?><axis2ns92:input xmlns="
http://soa-matrix.com/tataref/xform" xmlns:axis2ns92="
http://soa-matrix.com/tataref/xform">
<TicketID>12191558</TicketID>
<Region xmlns:soa="
http://soamatrix.com/esb/SOAStoreService/">RegionSouth</Region>
<Circle xmlns:soa="
http://soamatrix.com/esb/SOAStoreService/">Circle</Circle>
<Cluster xmlns:soa="
http://soamatrix.com/esb/SOAStoreService/">Cluster</Cluster>
<EquipmentTypeCode>1</EquipmentTypeCode>
<SiteID>KARBLR0068</SiteID>
<AlarmCategory>power</AlarmCategory>
<AlarmName>AC Input to PP fail</AlarmName>
<Severity>critical</Severity>
<Manual/>
<CustomerName>sdgtfhfyhjgyjyu</CustomerName>
<EmailID>rahul@soa-matrix.com</EmailID>
<ContactNo>9980012345</ContactNo>
<Description>test 12june 2010</Description>
<AssignToRole>default\engineersite1</AssignToRole>
<Status>underService</Status>
</axis2ns92:input>