On Feb 12, 2007, at 1:02 AM, MB Software Solutions wrote:
> I know that all of my keys are going to be positive, hence I've
> indicated that the PKs should be UNSIGNED. Likewise, I've made their
> FKs in other tables unsigned as well.
>
> Is this prudent, foolish, or doesn't matter? Just curious....
It just doubles the number of available values, since the sign bit
can be used as part of the number. So instead of a range of -n to +n,
you get a range of zero to +2n.
I make all my keys autoincrement, which means that they will never
be negative, so they are unsigned integers.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
