I currently have a text field where a very long XML string is being saved. I know the text type is deprecated.
I am using MS SQL 2008. Which data type should I use to replace it and why.
I changed it to varbinary(max) for the time being as suggested by someone here, but I want to know if this is the best option and why compare to varchar(max) for example.