Unsigned numeric datatypes containing only positive values - by Manoj Pandey (manub22)

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 811859 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 12/17/2013 8:18:05 PM
Access Restriction Public


While creating Surrogate or Primary Keys by using INT or BIGINT datatypes most of the time I wonder if they I will reach their max limit in near future then what would I do? Due to this many a times I or many other developers tend to use BIGINT or GUIDs instead of INT.

I would recommend to have a UNSIGNED prefix before INT & BIGINT datatypes, so that they will contain only positive values. Thus doubling up the positive values that can contain now.

Manoj Pandey
Sign in to post a comment.