Page 214 - Computer - 10(A&B)

Fields can be of different types depending on the data they contain. Data types in LibreOffice Base are broadly
classified into five categories listed below.
v Alphanumeric data type v Date/Time data type

v Numeric data type v Other data type
v Binary data type

Alphanumeric Data Type

Alphanumeric data type is a description of data that is both letters and numbers enclosed within single or
double quotes. For example, “1a2b3c” is a short string of alphanumeric characters. Alphanumeric is commonly
used for password field.
The different types of alphanumeric data types available are listed here.

Name Data Type Description
Char Text (fix) Used to store a string made up of a fixed number of charactres.

Varchar Text Used for a short string of text, such as names or addresses.
Longvarchar Memo Used to store a large amount of text, such as a description
field.
Varchar_Ignore Case Text Stores up the specified length. Comparisons are not case
sensitive, but stores capitals as you type them.

Numeric Data Type
Numeric data type is used for describing numeric values for a the field. Numeric data types in a database can
be used for storing information such as mobile number, roll number, marks, price of the product, quantity of
product, true or false statements, etc.
The different types of numeric data types available are listed here.

Name Data Type Description
Integer Integer Represents an integer; the minimum and maximum values depend
on the DBMS.

Smallint Smallint Same as INTEGER type except that it might hold a smaller range
of values, depending on the DBMS.

Bigint Bigint Same as INTEGER type except that it might hold a larger range of
values, depending on the DBMS.
Decimal Decimal It allows you to define the number of decimal places.

Numeric Numeric Exact numerical, precision p, scale s; the maximum precision
depends on the DBMS.
Float/ Real/ Double Float/Real/Double Approximate numerical, mantissa precision p; precision is greater
than or equal to 1 and the maximum precision depends on the
RDBMS.

Boolean Yes/No This data type is good for Yes or No questions about a record. (e.g.
Has the bill been paid?). Zero is considered as false, and nonzero
values are considered as True.
Tinyint Tinyint It is used to store numbers ranging from 0 to 255.

96