adspace


Difference between CHAR and VARCHAR?

Answer Posted / Mithilesh Kumar Pandey

In MySQL, the main difference between CHAR and VARCHAR is that CHAR uses a fixed length for storing data, while VARCHAR uses variable length. For example, if you create a CHAR column with a length of 10, it will always take up 10 bytes, even if you store a smaller value. On the other hand, VARCHAR only takes as many bytes as necessary to store the data.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to Change a users password from unix shell.

1222


Which statement is used in a select query for partial matching?

1247


What is the current mysql version?

1103


What is current version of mysql?

1083