Possibly, I use Transact SQL 2000 and 2005 varchar supports upto 8000, varchar(max) (in 2005) is pretty much the same as varchar(8000).
That said using varchar(max) means when there's a new release of SQL and the varchar field is extended the varchar(max) fields will extend too when you migrate so I guess it makes it more future proof.
I had no idea MySQL only allowed for 255... That's crap! But I suppose it's free! That said MySQL is just wierd and has 'interesting' stored procedure implementation.
The Text field allows 2,147,483,647 characters in SQL 2005 which may be described as overkill for a person's name?! ;)
That said using varchar(max) means when there's a new release of SQL and the varchar field is extended the varchar(max) fields will extend too when you migrate so I guess it makes it more future proof.
I had no idea MySQL only allowed for 255... That's crap! But I suppose it's free! That said MySQL is just wierd and has 'interesting' stored procedure implementation.
The Text field allows 2,147,483,647 characters in SQL 2005 which may be described as overkill for a person's name?! ;)