I have a table that currently has a text field I am trying to switch it to a different datatype, like varchar(8000). This worked great for most of my databases, unfortunately there are 4 out of 20 that seem to have more data than 8000 characters in that field so changing to varchar(8000) would truncate the data.
Is there a data type I can use that is NOT text and is more than 8000 characters? I think 16000 would do, but varchar won't' support that many characters.
I won't get into why I don't want to use text, just gives me way too many issues.