I'm a rookie when it comes to XML data.I currently have a database with xml data being stored in a \[code\]ntext\[/code\] column and this database appears to be taking up too much space. I'm trying to improve the way the data is stored, to reduce the overall size of the DB.The way I see it, I have two options:
\[code\]nvarchar(max)\[/code\]
\[code\]xml\[/code\]
I will need to test the two options above by importing some data into those columns.The problem I am having is, the XML data in the ntext column is currently stored as utf-8. In order for me to import it into the XML data type column, I will need to CAST/CONVERT the data to UTF-16?Is this right?
