Ed Leafe wrote: > On Feb 12, 2007, at 9:32 AM, MB Software Solutions wrote: > > >> 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? >> > > The default for integer fields is signed. If you know that you will > never have negative values, as in an autoincrement field, you need to > specify unsigned. > >
Ok. I knew about the range going from 0 to 2n+1 rather than -n to n. I wondered about the performance...its probably negligible if any difference at all. In Comp Sci land, it's just doesn't have to worry about doing the 2's complement to get the negative value....but again, probably doesn't even show up on the radar of performance. <g> Thanks, Ed. -- 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.
