DB Design

[mayu03]

What data type should be for a fields with values (0/1)or(Y/n).

 

[BrianLW]

Bit Field

 

[MakeItSo]

I'd suggest Bit type

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[MakeItSo]

OK Brian, you were quicker! :-D

 

[r937]

actually, to be pedantic, Y/N will not fit into a bit field, you need at least a byte to represent a character, but i'm going to assume what is actually desired here is a boolean

my suggestion: smallint with a check constraint for value in (0,1)

that way you can count true rows with sum()



rudy

http://r937.com/

SQL Consulting