What Are the Differences between CHAR and VARCHAR2

Q

What Are the Differences between CHAR and VARCHAR2? - Oracle DBA FAQ - Understanding SQL Basics

✍: FYIcenter.com

A

The main differences between CHAR and VARCHAR2 are:

  • CHAR stores values in fixed lengths. Values are padded with space characters to match the specified length.
  • VARCHAR2 stores values in variable lengths. Values are not padded with any characters.

2007-04-24, 4706👍, 0💬