Use XML Data Type instead of NTEXT

[atifaziz]

From @atifaziz on August 25, 2015 16:33

Use the XML data type instead of NTEXT with SQL Server.

The XML data type allows usage of XQuery to query the XML itself. This can typically be used to extract columns of data from XML nodes for filtering, reporting, etc, and has the potential to be used in computed columns as well.

See the XQuery language reference for more information.

---

Originally reported on Google Code with ID 265

Reported by msumerano on 2012-01-06 04:07:17

Copied from original issue: elmah/Elmah#265

[atifaziz]

NTEXT has been used so far because SQL Server 2000 did not support XML when ELMAH was initially release and we've had to maintain backward compatibility throughout 1.x. It's certainly something worth considering for the next major release.

---

Reported by @atifaziz on 2012-01-06 06:44:58

• Labels added: Component-Persistence

[atifaziz]

Yes, I would also strongly vote FOR using the XML datatype instead of NTEXT !

---

Reported by mscheuner on 2012-01-12 18:23:48

[atifaziz]

From @DancesWithBamboo on February 7, 2018 20:17

NTEXT is now deprecated on Sql Server 2016/17 and most likely won't be available in the next release. Whether or not to change to XML can be debated; but it's either that or varchar(max) very soon.