SQL types with PDO_4D and PHP
(No version information available, might only be in Git)
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 |