Almost 10 months later, I'm still waiting for a respond to my question. We have an application that import CSV files into SQL tables but we also need to keep the original CSV content for X number of months. I am currently saving the CSV data into a VARCHAR(MAX) field. I would like to know if I can use C1Zip to compress the data before writing to SQL. Do I need to use VARBINARY(MAX)?
Thank you