What's the DataType of NULL

ganga · New User Joined: 16 Mar 2005 Posts: 7

Hai,
i am new member to this group.Null is the what data type.
options are:
1.character
2.integer
3.Binary large objects

rick · New User Joined: 18 Jun 2004 Posts: 59 Location: Chennai

Hi,

I thinks NULL doesn't belong to any data type.

ovreddy · Posted: Sat Mar 19, 2005 6:57 pm

Hi Ganga,

NULL means nothing to enter or not applicable. For example take a table for storing employee information as EMPNO,ENAME,JOB, SAL,COMMISSION and DEPTNO. But only sales department people will have COMMISSIONS then what will be the value of COMM for others? that is NULL. The same situation can be applied for CHAR, VARCHAR or DATE types also. SO THERE IS NO SPECIFIC DATA TYPE FOR A NULL.

Bye,
Reddy.

ganga · New User Joined: 16 Mar 2005 Posts: 7

Hai ovreddy
thank you
regards
ganga

learnmf · Active User Joined: 14 Mar 2005 Posts: 123

HI ganga
Can you post rest of your Doubt as another posting.,another subject.

superk · Posted: Thu Mar 31, 2005 7:19 pm

learnmf · Active User Joined: 14 Mar 2005 Posts: 123

Hi supark
You put me in a great confussion.Suddenly i can't understand any thing what u did.Strange..............

Thanks
Learnmf

learnmf · Active User Joined: 14 Mar 2005 Posts: 123

Hi supark
it is better if you can split it with the respective answer.

Thanks