Data Types

Table of Contents

Type Mapping

Returned Values

When returning values, this driver maps CrateDB types to native PHP types:

CrateDB Type PHP Type
boolean boolean
byte  
short integer
integer integer
long integer
float float
double float
string string
ip string
timestamp integer
geo_point array
geo_shape object
object object
array array

Query Values

When using values in a query, you must bind them to a PDO parameter class constant, using either bindParam() or bindValue().

We recommend the following bindings:

CrateDB Type PDO Type
boolean PDO::PARAM_BOOL
byte,  
short, PDO::PARAM_INT
integer PDO::PARAM_INT
long PDO::PARAM_LONG
float, PDO::PARAM_FLOAT
double PDO::PARAM_DOUBLE
string PDO::PARAM_STR
ip PDO::PARAM_STR
timestamp PDO::PARAM_TIMESTAMP
geo_point PDO::PARAM_ARRAY
geo_shape PDO::PARAM_OBJECT
object PDO::PARAM_OBJECT
array PDO::PARAM_ARRAY