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`

There are no user contributed notes for this page.