Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Server 2000 - Unsigned Integers

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-12-05 : 07:28:34
Dustin writes "What would you consider to be the best practice to use an unsigned 32-bit integer? For our application we need several 32-bit unsigned integers and I would hate to use a bigint just for a 32-bit field. Even a binary(4) require a 4 byte overhead which is just as bad as a bigint (8 bytes of storage). Thanks for your help.

SQL Server 2000"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-05 : 07:38:19
Why can't you use SIGNED 32-bit integer?
Are you doing some bit operations?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -