ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  SQL Data Types
Subject:   Storage level difference between Char and Binary types
Date:   2007-01-16 01:04:34
From:   jack.oracle
Response to: Storage level difference between Char and Binary types



if u have char type of lenth 6 and u store only 4 charecter in data type it will take 6 byte on disk
if u have varchr2 of 6 lenth and u stor only 3charecter in data type it will take only 3 byte on disk