Women in Technology

Hear us Roar



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

Main Topics Oldest First

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