Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between CHAR and VARCHAR2?What is the
maximum SIZE allowed for each type?
- 6 Answers
- 33607 Views
- Saama Tech, I also Faced
- E-Mail Answers
Answer Posted / esakkiraja
CHAR
-----
SQL> CREATE TABLE char_test (col1 CHAR(10));
Table created.
SQL> INSERT INTO char_test VALUES ('qwerty');
1 row created.
SQL> SELECT col1, length(col1), dump(col1) "ASCII Dump"
FROM char_test;
COL1 LENGTH(COL1) ASCII Dump
---------- ------------ ------------------------------------
------------------------
qwerty 10 Typ=96 Len=10:
113,119,101,114,116,121,32,32,32,32
VARCHAR
-------
SQL> CREATE TABLE varchar_test (col1 VARCHAR2(10));
Table created.
SQL> INSERT INTO varchar_test VALUES ('qwerty');
1 row created.
SQL> SELECT col1, length(col1), dump(col1) "ASCII Dump"
FROM varchar_test;
COL1 LENGTH(COL1) ASCII Dump
---------- ------------ ------------------------------------
------------------------
qwerty 6 Typ=1 Len=6: 113,119,101,114,116,121
VARCAHR2
----------
SQL> CREATE TABLE varchar2_test (col1 VARCHAR2(10));
Table created.
SQL> INSERT INTO varchar2_test VALUES ('qwerty');
1 row created.
SQL> SELECT col1, length(col1), dump(col1) "ASCII Dump"
FROM varchar2_test;
COL1 LENGTH(COL1) ASCII Dump
---------- ------------ ------------------------------------
------------------------
qwerty 6 Typ=1 Len=6: 113,119,101,114,116,121
VARCHAR vs. VARCHAR2
---------------------
1. VARCHAR is going to be replaced by VARCHAR2 in next
version. So, Oracle suggests the use VARCHAR2 instead of
VARCHAR while declaring datatype.
2. VARCHAR can store up to 2000 bytes of characters while
VARCHAR2 can store up to 4000 bytes of characters.
3. If we declare datatype as VARCHAR then it will occupy
space for NULL values, In case of VARCHAR2 datatype it will
not occupy any space.
CHAR vs. VARCHAR
----------------
VARCHAR is used to store variable length character strings
up to 4000 characters. But, remember CHAR is faster than
VARCHAR - some times up to 50% faster.
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Why do we use joins?
what is the difference between undefined value and null value? : Sql dba
How subquery works in sql?
What is the use of partition by in sql?
What is pl sql block structure?
Are stored procedures faster than dynamic sql?
What is rownum?
What is the starting oracle error number?
Can a foreign key have a different name?
Why do we use function in pl sql?
What is data definition language?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What are tuples in sql?
what is a primary key? : Sql dba
Explain the components of sql?
