Data types¶

Table of contents

Type mapping
- Returned values
- Query values

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`