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.