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.

IT PHP 编程语言 Linux 科技开发编程 Elasticsearch HTML/CSS/XML 网络 JAVA NoSQL C/C++ 面试数据库 Golang Git 算法正则表达式操作系统 Redis 互联网 MySql JavaScript 运维软件架构设计 Mac OS 国际 TCP/IP Excel Vim Windows Socket Oracle VR MongoDB 运营 Python MemCache 商业硬件电子设计娱乐 nginx 摄影游戏 WordPress HTTP 团建数码电器

略微加速