InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Differences between varchar and char. |
| Answer» CHAR\tUsed to store character string value of fixed length.\tThe maximum no. of characters the data type can hold is 255 characters.\tIt\'s 50% faster than VARCHAR.\tUses static memory allocation.VARCHAR\tUsed to store variable length alphanumeric data.\tThe maximum this data type can hold is up to\tPre-MySQL 5.0.3: 255 characters.Post-MySQL 5.0.3: 65,535 characters shared for the row.\t\t\tIt\'s slower than CHAR.\tUses dynamic memory allocation*. | |