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