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

Send feedback on this subject.