Please support our MySQL advertiser: Programming Forums
Views: 24358 | Replies: 2
 |
•
•
Join Date: Jun 2005
Posts: 20
Reputation: 
Rep Power: 4
Solved Threads: 0
Newbie Poster
IWhat exactly is the "unsigned" use for in sql and when should i consider using it?
•
•
Join Date: Jun 2005
Location: Kansas City, Missouri, USA
Posts: 345
Reputation:
Rep Power: 4
Solved Threads: 4
Posting Whiz
The best I can gather from the documentation is that "signed" or "unsigned" refers to the plus or minus sign a person would traditionally use to indicate a positive or negative value. So an UNSIGNED numeric value can never be negative.
Therefore, if you have a column that you want to contain a numeric value, but never hold a negative value, I guess you could apply the UNSIGNED modifier to the data type.
http://dev.mysql.com/doc/refman/5.0/...-overview.html
Therefore, if you have a column that you want to contain a numeric value, but never hold a negative value, I guess you could apply the UNSIGNED modifier to the data type.
http://dev.mysql.com/doc/refman/5.0/...-overview.html
•
•
Join Date: Oct 2004
Location: San Francisco, CA
Posts: 338
Reputation:
Rep Power: 5
Solved Threads: 2
Posting Whiz
the biggest difference is an unsigned number cannot be negative (just as stated above)
but the benefit of usign an unsigned number is that you can have a greater range of positive numbers.
Tinyint: The signed range is -128 to 127. The unsigned range is 0 to 255.
Mediumint: The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215.
Bigint: The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615.
you get the point from there, a great use of unsigned numbers is for any column that has an auto_increment flag on it, since it will never be negative
but the benefit of usign an unsigned number is that you can have a greater range of positive numbers.
Tinyint: The signed range is -128 to 127. The unsigned range is 0 to 255.
Mediumint: The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215.
Bigint: The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615.
you get the point from there, a great use of unsigned numbers is for any column that has an auto_increment flag on it, since it will never be negative
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
