Home | Previous Page | Next Page   Object-Relational Databases > Creating and Using Extended Data Types in Dynamic Server >

Informix Data Types

Figure 22 in Choosing Data Types provides a chart for selecting appropriate data types for the columns of a table depending on the type of data that will be stored. Figure 24 shows a hierarchy of data types that reflects how the database server manages the data types.

Figure 24. Informix Data Types
begin figure description - The chart is made up of rectangles representing categories of data. They are connected in a hierarchy by solid lines. There is also one connection that is a dashed line. At the top of the chart is "DATA TYPES". "DATA TYPES" has two children: "Built-in data types" and "Extended data types". The "Extended data types" rectangle contains a note to see Figure 7-2. "Built-in data types" has two children. One of them is "Predefined data". The connection to "Predefined data" is a dashed line instead of a solid line. "Predefined data" is also a child of "Extended data types". The other child of "Built-in data types" is "Fundamental or atomic". "Fundamental or atomic" has four children: "Character", "Numeric", "Time", and "Simple Large Objects: TEXT BYTE". These four have no children. "Extended data types", which is a child of "DATA TYPES", has one child: "Predefined data". "Predefined data" has four children: "LVARCHAR", "BOOLEAN", "Smart Large Objects: BLOB, CLOB", and "Other predefined data types". These four have no children. - end figure description
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]