Is there any advantage of last_name varchar(50) over this last_name varchar(255)?
- 1 Answers
- 992 Views
- I also Faced
- E-Mail Answers
Answer Posted / Shailendra Gautam
The primary difference between last_name varchar(50) and last_name varchar(255) is the maximum length of the last_name variable. If you know that the length of the last names in your database will not exceed 50 characters, using a smaller data type such as varchar(50) can save storage space and improve performance. However, if there's a possibility that some last names might be longer than 50 characters, it's better to use a larger data type like varchar(255) for flexibility.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
