Search code examples
sqlvarchar

SQL: Why is varchar(50) the default?


When I create a new VARCHAR column in Microsoft SQL Server Manager Studio, it defaults to 50 length. Does this length have some special meaning? If theoretically I have the option to choose for a length between 30 and 70, is isn't it better to go for defaults that are power of 2 (like 32, or 64 in this case)?


Solution

  • Because its a nice small round number... Seriously I would think that its pretty arbitrary decision that was made.