The following conventions are imposed on the database schema to maintain compatibility between the supported database environments:
All date/time fields are represented as a long data type. The value of the date/time field is the time in milliseconds since January 1, 1970 (UNIX EPOC time).
Numeric fields use the NUMBER data type, which is supported by all certified databases.
Boolean values are stored as a SMALLINT data type where 0 is false and 1 is true. It is the responsibility of the application code to convert to the proper data type after the data has been retrieved.
All binary data is stored as a LONG RAW data type because all databases do not support the BLOB and CLOB native data types.