Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (20.3k points)

I have a simple webform that will allow unauthenticated users to input their information, including name. I gave the name field a limit of 50 characters to coincide with my database table where the field is varchar(50), but then I started to wonder.

Is it more appropriate to use something like the Text column type or should I limit the length of the name to something reasonable?

I'm using SQL Server 2005, in case that matters in your response.

EDIT: I did not see this broader question regarding similar issues.

1 Answer

0 votes
by (40.7k points)

According to UK Government Data Standards Catalogue35 characters are suggested for each Given Name and Family Name, or 70 characters for a single field to hold the Full Name.

Browse Categories