In sql server 2012, I would like to know what datatype can hold the maximum number of characters? (The datatype will need to contain letters, numbers, and potentially any special characters.)
In addition, to insert, update and delete data from this datatype, is there any special t-sql that is required?
I am asking this question since I know sql server 2000 had the blob datatype and that required some 'special' t-sql to update the data in this data type.
In addition, would you tell me what other few datatypes are available and what the maximum number of characters each datatype can hold?
**Note, I do not need any data that contains 'N' values since I am only working with data where people speak English.