What is the difference between char and varchar data types?

Answer Posted / deven verma

char stores only character values whereas varchar can
stores alphanumerics values. searching is faster in char in
comparision of varchar

Is This Answer Correct ?    53 Yes 80 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the default port for MySQL Server?

577


How you will show all data from a table.

523


How to make a copy values from one column to another in mysql?

569


How to create a new table by selecting rows from another table in mysql?

502


How to validate email addresses in mysql?

602






How to control the max size of a heap table?

553


Is mysql a scripting language?

476


Which is faster mongodb or mysql?

458


What are Heap tables?

842


What is the latest version of mysql?

502


What is the innodb in mysql?

508


What are mysql queries?

484


What is an example of a delimiter?

498


What is a mysql server?

520


What are the difference between mongodb and mysql?

656