That was my standard reasoning when setting varchar fields but if I'm storing email subjects then there may be more than 255 characters. Why limit myself to a standard that has little to do with what I'm actually doing.
To add to my question, is there an optimal varchar size for indexing/searching? Thanks >I use 255 because that is the max that a text form field will take. > > >> >> In MS SQL 2000, is there an optimal size for varchars? Specific size >> chunks? I'm looking at a size over varchar(250) and the better the >> better. >> 255? >> 256? >> 512? >> something else? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3342 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
