March 29, 2012 at 9:36 am
In a new table in sql server 2008 R2 that I will be setting up, I am wondering if there is a problem setting up a column size to be varchar(max) for a 'description' column I am using? I am asking the question since I am obtaining datata from a user daily from an excel spreadsheet. The maximum size for a value in an excel spreadsheet is 32,767 characters. My company says I can not ask the customer anything, I just need to work with what they give us.
Do you have any suggestions?
March 29, 2012 at 9:45 am
wendy elizabeth (3/29/2012)
In a new table in sql server 2008 R2 that I will be setting up, I am wondering if there is a problem setting up a column size to be varchar(max) for a 'description' column I am using? I am asking the question since I am obtaining datata from a user daily from an excel spreadsheet. The maximum size for a value in an excel spreadsheet is 32,767 characters. My company says I can not ask the customer anything, I just need to work with what they give us.Do you have any suggestions?
Since you can't talk to the customer directly and you've been told to work with what they give you, go for the worst case scenerio, use varchar(max).
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply