What is difference between CHAR and VARCHAR2?What is the
maximum SIZE allowed for each type?
- 6 Answers
- 32679 Views
- Saama Tech, I also Faced
- E-Mail Answers
Answer Posted / sushant
Both CHAR and VARCHAR2 types are used to store string values but both behave very differently.
CHAR should be used to store fix length strings. String values will be space/blank padded towards right before storing on disk. If this type is used to store varibale length strings, it will waste a lot of disk space. For example we can use it to store fields where we have one character only like IS_MINOR char (1). Here we will store only 'Y' or 'N' hence it becomes a prefect candidiate for char data type.
VARCHAR2 is used to store variable length character strings. The string value's length will be stored on disk with the value itself.
Explanation with an example could be found here :
http://www.oraclebin.com/2012/11/difference-between-char-and-varchar2.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is innodb? : Sql dba
What is procedure and function?
What is sql and how does it work?
What are triggers and its types?
What are the sql aggregate functions?
What is AUTH_ID and AUTH_USER in pl/sql ?
What is on delete restrict?
How do I make my sql query run faster?
How do I know if I have sql express or standard?
How can a pl sql block be executed?
What is the difference between sql and mysql?
What is scalar and vector?
What is an implicit commit?
explain about mysql and its features. : Sql dba
Which join is like inner join?
