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 |
What is heap table?
What is difference between statement and preparedstatement?
What does mysql workbench do?
How do I view mysql logs?
What is identity in mysql?
What is difference between schema and table?
Why use stored procedures in mysql?
How to check server status with 'mysqladmin'?
How do I copy a table in mysql?
Does mysql use sql?
Can't connect mysql server on localhost?
How to enter Characters as HEX Numbers?