Which datatype should be use to store sign number?

Hardevsinh Mori

9y1.5kSQL

i want know that which data type should be use to store plus minus sign with number

For Ex,

Column

-1

-2

When i try to get Sum(Column) it should be return 0.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manikandan Murugesan9y ago
Accepted 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.
Rajkiran Swain9y ago
https://www.quora.com/What-data-type-should-I-use-for-n-10-18
Gokhul Varman9y ago
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 Jha9y ago
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 P9y ago
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))
Rafnas T P9y ago
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
Manish Kumar9y ago
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
Amit Gupta9y ago
If it was only an integer number then int datatype else if it contains floating points values then decimal datatype should be sufficient.