Question

What should one use CHAR data type or VARCHAR data type in MySQL?

Answer 1

Hey mate!!

If the data that you want to store is a fixed size, you should use the CHAR data type. You'll get a better performance in comparison with VARCHAR in this case. The length of the CHAR data type can be any value from 0 to 255. When you store a CHAR value, MySQL pads its value with spaces to the length that you declared.