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.
-- 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.
