Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between CHAR and VARCHAR data types?

Answer Posted / rajan vardawaj

CHAR is a fixed length data type. CHAR(n) will take n
characters of storage even if you enter less than n
characters to that column. For example, “Hello!”

will be stored as “Hello! ” in CHAR(10) column. VARCHAR is a
variable length data type. VARCHAR(n) will take only the
required storage for the actual number

of [...]

Is This Answer Correct ?    27 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why use mysql procedures?

990


What is timestamp in mysql?

985


How to create a table?

998


How to get data from mysql in php?

905


What are the non-standard sql commands supported by 'mysql'?

996


In which year mysql created?

977


What are the steps required to view your mysql database?

1090


Why phpmyadmin is used for mysql?

947


How do I find the database name in mysql?

956


Can we create table in stored procedure?

962


Can not connect to mysql server 10060?

924


What is the role of a limit in a mysql query?

1009


What is mvcc in mysql?

1000


How do I restore a mysql database?

1090


How to check if value already exists in mysql database in php?

890