This is an old revision of the document!

The MetaType

The lowest level of information that ADOdb supports is the MetaType. This object represents the type of field in a consistent, simplified format.

Actual Types

Data is stored in the database in fields that best represent the type of data, e.g. Integer, character, floating point. These types may be subclassed further, e.g Small,Medium,Large integers. In addition, there may be estoric field types such as geometry, points etc. ADOdb refers to these types as Actual Types.

In total, ADOdb knows about 150 different Actual data types, and can simplify them down to 9 MetaTypes.

Type	Represents Field Types
C	character fields that should be shown in a <input type=“text”> tag
X	TeXt, large text or CLOB fields that should be shown in a <textarea>
B	Blobs, or Binary Large Objects. Typically images.
D	Date (sometimes DateTime) field
T	Timestamp field
L	Logical field (boolean or bit-field). Some databases emulate logicals using I2 fields
I	Integer field, This may be broken down further into I2,I4 or I8 types to represent small,medium and large integers. The largest integer data size is always represented by an I field
N	Numeric field. Includes autoincrement, numeric, floating point, real and integer.
R	Serial field. Includes serial, autoincrement integers. This works for selected databases. Some databases do not signify if a field is auto-increment

← Introduction

Start Of Lesson

MetaColumns →