I know that the Sql equivalent of Int16 is SqlInt16.
But what is the Sql equivalent of UInt16, UInt32 and Uint64?
Asked
Active
Viewed 2,009 times
1 Answers
3
Except for tinyint, there are no native unsigned types in SQL server so there is no good equivalent. The best you can do is use a bigger precision number and add a constraint on the permissible values.
JaredPar
- 733,204
- 149
- 1,241
- 1,454
-
2MySQL has the UNSIGNED attribute, if you can use it. – LiraNuna Oct 17 '09 at 21:24
-
But what would be the case of UInt64? What would be thye bigger precision? – user366312 Oct 17 '09 at 21:30
-
@JMSA, I'm not familiar enough with SQL's data types to provide a good answer to that. Hopefully someone else will chime in with a bigger type that can suite this need. – JaredPar Oct 17 '09 at 22:39
-
Assuming SQL Server, for Unit 64: decimal(20,0) with a check constraint between 0 and 18,446,744,073,709,551,615. – Shannon Severance Oct 18 '09 at 05:25