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

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