Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between CHAR and VARCHAR data types?
- 2 Answers
- 8978 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 |
Write a query to find duplicate rows in table?
How to load data files into tables with 'mysqlimport'?
How can you handle the –secure-file-priv in mysql?
how we will Show selected records sorted in an ascending (asc) or descending (desc).
What is database engine in mysql?
What are the column comparisons operators?
what is the difference between between and in operators in mysql?
What does myisamchk do?
How do I change mysql password?
Can mysql scale horizontally?
How do I create a schema in mysql?
What are the non-standard sql commands supported by 'mysql'?
-
Oracle (3253) - 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)
