Constants for PDO_4D
SQL acceptable by 4D
4D (PDO)
PHP Manual

# SQL types with PDO_4D and PHP

SQL types with PDO_4D and PHP

Supported SQL types
Type SQL 4D | Equivalent 4D | Note
--- | --- | ---
ALPHA_NUMERIC | TEXT |
VARCHAR | TEXT |
TEXT | TEXT |
TIMESTAMP | DATE |
INTERVAL | HOUR |
DURATION | HOUR |
BOOLEAN | BOOLEAN |
BIT | BOOLEAN |
BYTE | INT32 |
INT16 | SMALLINT |
SMALLINT | SMALLINT |
INT32 | INT32 |
INT | INT32 |
INT64 | INT64 |
NUMERIC | INT64 |
REAL | REAL | Unsupported (use VARCHAR conversion)
FLOAT | FLOAT | Unsupported (use VARCHAR conversion)
DOUBLE PRECISION | FLOAT |
BLOB | BLOB | Must use a prepared statement, and `PDO::PARAM_LOB`
BIT VARYING | BLOB | Must use a prepared statement, and `PDO::PARAM_LOB`
CLOB | TEXT |
PICTURE | PICTURE | Must use a prepared statement, and `PDO::PARAM_LOB`