Forum Discussion
Only 64-Bit Data Type in Data Models?
In my view, the Int.. types can only be used to have an error generated if a number is outside its range (see below), except for Int64 which is the general type for whole numbers.
Int8: -256 - +255
Int16: -32,768 - +32,767
Int32: -2,147,483,648 – +2,147,483,647
Int64: -9,223,372,036,854,775,808 - +9,223,372,036,854,775,807
Almost correct. Numbers are stored in 64-bit; depending on the data type these can be integers or (floating point) decimals.
The range for Int8 = -128 thru 127.
So, does this mean I had to stop micromanaging my data types - the Int ones?
What I'm doing is I'm going through each one and evaluating their ranges (Int8, Int 16, Int32, Int64).
In my view, the Int.. types can only be used to have an error generated if a number is outside its range (see below), except for Int64 which is the general type for whole numbers.
Int8: -256 - +255
Int16: -32,768 - +32,767
Int32: -2,147,483,648 – +2,147,483,647
Int64: -9,223,372,036,854,775,808 - +9,223,372,036,854,775,807
Then I think I could agree specially that I haven't read that there is such Data Types for Power Query. Thank you!