Article:		SQL Data Types
Subject:		Storage level difference between Char and Binary types
Date:		2005-04-29 02:42:47
From:		Apaku
Hello, The article gives a nice picture of data types. I do want to know the basic difference between "Char" and "Binary" data types from storage and retrieval perspective. Thanks and best wishes, Pavan

Showing messages 1 through 1 of 1.

• Storage level difference between Char and Binary types
  2007-01-16 01:04:34  jack.oracle [View]
  
  
  
  
  
  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