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

How do I know if mysql is installed on windows?

487


How do I check mysql version?

499


How you can create a trigger in mysql?

553


Is mysql frontend or backend?

486


what is constraints? Also explain the different types of constraints?

529






How to write date and time literals?

562


How do I quit mysql?

494


1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

1941


What are the other commands to know the structure of a table using mysql commands except explain command?

552


Why should I use mysql?

510


How you will show all data from a table.

527


What is auto increment in mysql?

509


How to Join tables on common columns.

650


Can varchar be primary key?

510


What is the data source name for mysql?

488