<NewDataSet> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:IsDataSet="true"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="Table"> <xs:complexType> <xs:sequence> <xs:element name="code" type="xs:string" minOccurs="0" /> <xs:element name="descr" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema> <Table> <code>S1</code> <descr>TEST </descr> <descrf>TEST DESCR </descrf> </Table> </NewDataSet>If i use XmlToCursor( xml, "testTable", 4), it create the cursor but the colums are created as char(1), and the data is truncated.