What data types are supported across the various databases?
The only data types I have tested across the various databases are the ones that I have actually used within the various Radicore applications. These are all covered within the data access classes which I have written, starting with MySQL, then PostgreSQL and Oracle. The data types are as follows: • MySQL: • string fields – CHAR, VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT • numeric fields – TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT, DECIMAL, FLOAT and DOUBLE • date/time fields – DATE, TIME, DATETIME, YEAR and TIMESTAMP • boolean – can be implemented with a CHAR(1) or TINYINT(1) field (see below) • array fields – ENUM and SET • PostgreSQL: • string fields – CHAR, VARCHAR, and TEXT • numeric fields – SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, SERIAL, BIGSERIAL, NUMERIC and MONEY • date/time fields – DATE, TIME, and TIMESTAMP • boolean – can be implemented with a BOOLEAN, CHAR(1) or SMALLINT(1) field (see below) • array fields – ARRAY • Oracle: • string fields – CHAR, VARCHAR2, and C
