CODEWITHSUNDEEP
sql-server
Bryce
Bryce

Reputation: 447

Unable to find a numerical type in sql to store this large of value

I am having some issues with getting this data into my sql database. It keeps giving me errors stating it can not accept the data. I have used decimal which seems to fail. The only type I have got to work was varchar. However, I need to be able to be able to do math equations on the data which doesn't work with varchar.

The value is: 

4.453099999999999881

ERROR: data conversion error (truncation)

Upvotes: 0

Views: 38

Answers (1)

M0rtiis
M0rtiis

Reputation: 3784

Have you tried some FLOAT or DOUBLE? try DOUBLE PRECISION(52,30)

or FLOAT(53) (https://msdn.microsoft.com/en-us/library/ms173773.aspx)

http://dev.mysql.com/doc/refman/5.0/en/floating-point-types.html http://dev.mysql.com/doc/refman/5.1/en/problems-with-float.html

Upvotes: 1

Related Questions