Difference between CHAR and VARCHAR2 ? , Oracle FAQs -III

Message

   CHAR(size)  - It is a fixed length character data, size characters long. It is padded with BLANKS ON RIGHT to the full length of size. DEFAULT - 1 bytes,  MAXIMUM  -  255 bytes.

VARCHAR2(size)  -  It is a varable length char string having a maximum of size bytes.

MAXIMUM - 2000 bytes.

Author	Message
Faqs Admin Group Admin Joined: 13 Apr 2006 Location: India Online Status: Offline Posts: 14411
	CHAR(size) - It is a fixed length character data, size characters long. It is padded with BLANKS ON RIGHT to the full length of size. DEFAULT - 1 bytes, MAXIMUM - 255 bytes. VARCHAR2(size) - It is a varable length char string having a maximum of size bytes. MAXIMUM - 2000 bytes. Posted: 01 Jan 2008 at 12:04am

	IP Logged

Oracle FAQs -III
GenProgrammers : Database : Oracle FAQs -III