[dba-VB] True / false in SQL Server

jwcolby jwcolby at colbyconsulting.com
Mon Jan 16 11:08:38 CST 2012


Because of various issues with bit and Access I have always used int as the data type and -1 or 0 as 
the default value.  These can be bound directly to a check box (for example).

Because the default int is a 32 bit number I was just looking to see if I could use a smaller data 
type.  A smallint is 2 bytes and includes negative values.  A tinyint does not appear to allow -1. 
Is there a signed byte datatype that I am not seeing?

-- 
John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it



More information about the dba-VB mailing list