Ed Leafe wrote: > 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. >
I make all my keys autoincrement as well, but I never checked off the UNSIGNED box in my data designer...are you saying that they're unsigned by default if they're autoincrement? So do you need to explicitly set the foreign keys to UNSIGNED as well in this case? -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ 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.
