"The data at the root level is invalid" error on reading XML

[ozane]

i am trying to read an xml from binary field in SQL server. i read the blob correctly. but when i want to see file as xml "the data at the root level is invalid. line 1..." error appears.
i searched the web. i met that, the reason is: the xml is not an xml, it is text.
correct i have statement in my code
MyStrData = System.Text.UTF8Encoding.UTF8.GetString(MyData)

then i want to convert the binary to XML. but how can i do that? any idea...

 

[vbkris]

>> but when i want to see file as xml

when it comes from SQL server itself?

there is a FOR XML AUTO clause in SQL server, check it out...

Known is handfull, Unknown is worldfull