>>>Is there anyway around this without changing the XSD?
>>>
>>
>>Hi Mike,
>>
>>Manually change DataType property of the corresponding XMLField object after LoadXML.
>>
>>Thanks,
>>Aleksey.
>
>Hi Aleksey,
>
>I know its been a while since I raised this question. Thanks for the reply.
>
>I was wondering if you could provide more details about your suggestion. Are you saying that I could loop thru all of the XMLField objects and set some property named "DataType"? If so, to what? Some "large enough" size?
>
>Regards,
>
>Mike

Hi Mike,

Yes, if you think the data will fit into a Char or Varchar field, you can loop through XMLTable.Fields collection and change XMLField.DataType property from 'M' to 'C' or 'V' and XMLField.MaxLength to some "large enough" size.

Thanks,
Aleksey.