>>>>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.

Thanks Aleksey. I'll give that a try.

Mike