Raj,
What do you mean by :
'oracle still puts in a character to indicate
that this column has a NULL value' ?
Oracle does not insert anything into a nullable column when
the insert value is an empty string or a NULL.
This is true of both char and varchar2.
Or are you saying that oracle somehow tracks that a NULL
was inserted by use of a special character?
( Guess I could dump a block and find out, but it's easier
to ask you. :)
Jared
"Jamadagni, Rajendra" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/05/2002 09:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: char vs. varchar in a data warehouse
Lisa,
let it be varchar2 ... but the developers are not entirely right too.
oracle
still puts in a character to indicate that this column has a NULL value.
So, unless your storage is at premium, leave it as varchar2, because the
moment you make it CHAR, the comparison semantics change when you compare
that with varchar2 field and that would be an added cost for your SQLS.
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
*********************************************************************2
This e-mail message is confidential, intended only for the named recipient(s) above
and may contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank you.
*********************************************************************2
