[dba-VB] [AccessD] True / false in SQL Server

Stuart McLachlan stuart at lexacorp.com.pg
Mon Jan 16 16:52:09 CST 2012


Nope, smallint is the smallest signed integer.

On 16 Jan 2012 at 12:08, jwcolby wrote:

> 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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 

--
Stuart McLachlan

Ph:    +675 340 4392 
Mob: +675 7100 2028
Web: http://www.lexacorp.com.pg



More information about the dba-VB mailing list