Supported Data Types

Numeric types

Monetary types

Character types

Binary types

Date and time types

Boolean typess

Enumerated types

Geometric types

Network address typess

Bit string types

Text search types

UUID types

XML types

JSON types

Array types

Composite data types

Range types

Domain types

Object identifier types

Numeric types

ZEROFILL: Deep caches return ZEROFILL columns with the same zero padding as MySQL, and support ZEROFILL columns as join, grouping, ordering and lookup keys, in comparisons, and in COALESCE with an integer fallback. A deep cache cannot be created for a query that uses a ZEROFILL column in another way, such as in CONCAT, CAST, LIKE, arithmetic, an aggregate function or a window function, including inside the definition of a view that the query reads. The same holds for a query that returns a ZEROFILL column from the right side of a LEFT JOIN, from a scalar subquery or from a UNION ALL, or that returns a join key whose other key does not have the same ZEROFILL type. Such queries can be cached as shallow caches. A table with a FLOAT(M,D) or DOUBLE(M,D) ZEROFILL column is not replicated.

Date and time types

String types

JSON types

Spatial types