mysql> ALTER TABLE test.varchar_alter CHANGE COLUMN _varchar _varchar VARCHAR(200) NOT NULL DEFAULT '', ALGORITHM=COPY, LOCK=SHARED; Query OK, 0 rows affected (0.03 sec) ... Check the following sample ...

Learn the difference between CHAR and VARCHAR data types in SQL, how they affect storage and performance, and how to choose the best one for your database.