Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between CHAR and VARCHAR data types?
- 2 Answers
- 8884 Views
- Ramco, I also Faced
- E-Mail Answers
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 are the critical issues you have resolved in your company
What is view? How can you create and drop view in mysql?
How to include numeric values in sql statements?
What is auto increment in mysql?
Will mysql remain free?
How to returns the columns and column information pertaining to the designated table.
How to connect html form to mysql database using php?
List some comparisons operators used in mysql?
What is an example of a delimiter?
what is the difrence between sql and pl/sql
is it possible to assign two primary key in a table
In which language it is written?
-
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)
