DBA > Job Interview Questions > DATABASE Administrator (DBA) Interview Questions and Answers

What is difference between CHAR and VARCHAR2?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

109. What is difference between CHAR and VARCHAR2?

The difference between a CHAR and a VARCHAR is that a CHAR(n) will ALWAYS be N bytes long, it will be blank padded upon insert to ensure this. A varchar2(n) on the other hand will be 1 to N bytes long, it will NOT be blank padded

(Continued on next question...)

Other Job Interview Questions