Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2012-03-29 : 11:32:13
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-29 : 12:21:33
|
| it depends. if you've guarantee that description falls below 8000 characters you can go with varchar(8000). if not, you have to opt for BLOB type varchar(max)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
varchar options