SQL Server xml column

Hi,

1) xml column in table definition is like 'int' or 'tinyint' with 'max' lenght, strange no ?

2) How can I edit an xml column ? I can read it, but I have an error message when updating in design mode
(I must use a query like this to change only the -Auto Level- from 2 to 1 : UPDATE Acc_Zone SET Details = N'<?xml version="1.0" encoding="utf-16"?>
<Cfg xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Auto Id="2" Level="1" />
</Cfg>' WHERE Id = 130)

I have the same problem.
It is possible to fix this error in order to support data type xml? We are using MS SQL Server.

Hi,

XML columns of MS SQL Server are still not very well supported. Is it on the plan do improve this? I cannot edit the XML string or delete a row which contains an XML column.

Thanks in advance.