10.14.3.1 Reading from the database

When reading data from the database the following datatypes are supported, with conversion to the corresponding prolog datatypes.

SQL: CHAR

Prolog: code list

SQL: VARCHAR

Prolog: code list

SQL: BIT

Prolog: integer

SQL: TINYINT

Prolog: integer

SQL: SMALLINT

Prolog: integer

SQL: INTEGER

Prolog: integer

SQL: REAL

Prolog: float

SQL: DOUBLE

Prolog: float

SQL: FLOAT

Prolog: float

SQL: DATE

Prolog: date(Year, Month, Day)

SQL: TIME

Prolog: time(Hour, Minute, Second)

SQL: TIMESTAMP

Prolog: timestamp(Year, Month, Day, Hour, Minute, Second, Fraction)