CODEWITHSUNDEEP
androidsqlitefloating-pointdecimal
Shervin
Shervin

Reputation: 233

android sqlite REAL type

I was wondering how many exact places are there for decimal number in REAL data type in SQLite. If it is any difference, I think version 3 will be of the most use to know.

Upvotes: 2

Views: 2033

Answers (1)

Vivek Bajpai
Vivek Bajpai

Reputation: 1615

According to this sqllite documentaion REAL is floating number of 8 byte as described in IEE floating point format it can take up to 52 bit in fraction means in 16 bit enviornment it will be 1.0000000000000002 (smallest number greater than 1) 16 decimal place.

Upvotes: 3

Related Questions