What is the difference between CHAR and VARCHAR data types?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shekoli
Char is a fixed lenth datatype. Ex: char(7), welcome
but varchar is a variable length datatypes, Ex:
varchar(7),welcome (or) come
| Is This Answer Correct ? | 1 Yes | 0 No |
Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
How do I delete a mysql user?
Where is mysql installed on linux?
How large can a mysql table be?
What is mysql enterprise edition?
What is the difference between a database and a table?
Can you save your connection settings to a conf file?
What are the critical issues you have resolved in your company
how fastest access of data can be done from database ?
How do you determine the location of mysql data directory?
What are the features of mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)