Which datatype should be use to store sign number?

Question

i want know that which data type should be use to store plus minus sign with number For Ex, Column +1 -1 -2 +2 When i try to get Sum(Column) it should be return 0.

Manikandan Murugesan · Answer

The decimal datatype can store negative numbers as well. So to answer your question, yes you can use the decimal datatype to store negative decimal numbers. create table NegativeDecimal ( somedec decimal (10, 4) not null ) go insert into negativedecimal select -12.3 union all select 16.4 go select * from NegativeDecimal somedec --------------------------------------- -12.3000 16.4000 (2 row(s) affected) And also refer the following Link to get the Full view of using Datatypes : https://dev.mysql.com/doc/refman/5.7/en/integer-types.html Thank you.

Manish Kumar · Answer

Why you are storing record like this. Is some thing business requirement. It will only display - value for integer and float . + sign will not display because if you write some number with out any sign by default it will +ve

Rafnas T P · Answer

if you wanted to save + symbol as well then use nvarchar but when calculation time you have convert this column to integer like as follows Sum( cast( Column as int) )

Rajkiran Swain · Answer

https://www.quora.com/What-data-type-should-I-use-for-n-10-18

Gokhul Varman · Answer

If you referr the link you can get a clear solution about your problem:https://www.codeproject.com/Questions/280581/what-data-type-can-i-use-to-store-phone-numbers-in

Awadhesh Jha · Answer

Use Bigint or Decimal or Numeric . use length for decimal and numeric as per business requirement like numeric(14.0) or decimal(18,2) By default they store +ve values so no need to use +ve sign, for -ve value we can use -ve sign. For Ex. table name -scoreboard column name -score values are as given below 10.25 50.75 100 .00 -100.00 query will be like this select sum(score) from scoreboard Ans. 61

Rafnas T P · Answer

hi, you can use int datatype, but when you save with + symbol + symbol will not save for ex, +1 then it will be 1 +2 then it will be 2 if with - symbol it will save with - symbol for ex, -1 then it will be -1 -2 then it will be -2 when you do sum also will return 0 in this example

Amit Gupta · Answer

If it was only an integer number then int datatype else if it contains floating points values then decimal datatype should be sufficient.

Which datatype should be use to store sign number?

Answers (8)