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

explain GROUPBY & HAVING clause with examples.

2327


How to create a new table in mysql?

1097


What is unique key in mysql?

1050


Which statement is used to delete a table in MySQL.

954


Can we store pdf files in mysql?

1033


What is different between sql and mysql?

1070


what is constraints?

1232


What does the file with the extension: frm, myd, and myi contain?

984


What is mysqladmin flush hosts?

1012


What are the types of queries?

984


Is mysql a framework?

981


Is mysql running ubuntu?

1057


How to return query output in html format?

983


How to get a version of mysql?

1105


Is mysql a scripting language?

963