If we need to store URLs in a column of a table in SQL, what is the maximum length can we assign for the datatype?
I googled for couple of minutes and found some desired results.
Microsoft has posted that IE browser can allow maximum of 2083 characters.
http://support.microsoft.com/kb/q208427
For more information you can visit
http://www.boutell.com/newfaq/misc/urllength.html
According to above articles it is ideal to assign nvarchar(max) for URL column. If space consumption is a concern then we can give nvarchar(3000).
I googled for couple of minutes and found some desired results.
Microsoft has posted that IE browser can allow maximum of 2083 characters.
http://support.microsoft.com/kb/q208427
For more information you can visit
http://www.boutell.com/newfaq/misc/urllength.html
According to above articles it is ideal to assign nvarchar(max) for URL column. If space consumption is a concern then we can give nvarchar(3000).
No comments:
Post a Comment