They are made of a whole part and a partial part separated by a decimal point. Unless you using some extremely big numbers (calculating the distance to the next parallel world) or extremely small numbers (the size of a pit on an electron), you will not ever need to use this type.įloating-point numbers are numbers with decimals, or real numbers. Size is 2 64 = big, whopping whole numbers (i.e. The one exception is when you need extremely large integer numbers. You are pretty safe using this type for most of your integer needs. This is the type usually used for record identities.
INTEGER or INT – the most commonly used integer type, with a size of 2 32. Like the TINYINT, make sure your numbers will fall into this range. If you don’t need negatives, you get 65,536, but if you need negatives, the range is -32,768 to 32,767. SMALLINT – with a size of 2 16, this integer type gives you a little more breathing room. You shouldn’t use this type unless you can guarantee the numbers will always fall into this range. That is 1 to 256 if there are no negatives, and -128 to 127 if there are negatives. TINYINT – the smallest of the integer types. There are four integer types, and their differences are mostly related to size. We will look at five categories of data types in LibreOffice base: integers, floating point, text, time, and other. An understanding of the types and when you might, if ever, use them will help you as you create your tables for your database projects. Like any database system, HSQLDB has a rich set of data types to choose from when building your database. 
By default LibreOffice Base uses the HSQLDB database management system.
0 kommentar(er)
