10.14.3.2 Writing to the database

When writing data to the database the following SQL datatypes are supported.

SQL: CHAR, VARCHAR

Prolog: atom or code list

SQL: BIT

Prolog: integer

Any non-zero value will be stored as a 1.

SQL: SMALLINT

Prolog: integer

If the integer value is to large to be stored in a SMALLINT the result is undefined.

SQL: INTEGER

Prolog: integer

SQL: REAL

Prolog: float

If the float value is to large to be stored in a REAL the result is undefined.

SQL: DOUBLE, 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)

SQL: LONG

Prolog: integer