8. Type Handlers

General usage: 8. Type Handlers. Status links explain differences for each data source.

Data source	Basic types	Binary types	Time types	Enum types	JSON serialization	Array types	Custom handlers
MySQL	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	◐ Partial	✓ Supported
PostgreSQL	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported
Oracle	◐ Partial	◐ Partial	✓ Supported	✓ Supported	✓ Supported	◐ Partial	✓ Supported
SQL Server	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	◐ Partial	✓ Supported
DB2	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	◐ Partial	✓ Supported
H2	✓ Supported	✓ Supported	◐ Partial	✓ Supported	✓ Supported	✓ Supported	✓ Supported
ClickHouse	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	◐ Partial	✓ Supported
Redis	◐ Partial	◐ Partial	◐ Partial	◐ Partial	◐ Partial	✕ Unsupported	✕ Unsupported
MongoDB	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported
ES 6	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported
ES 7	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported
Milvus	✓ Supported	✕ Unsupported	✓ Supported	✓ Supported	✓ Supported	◐ Partial	✓ Supported

• Basic types: numbers, booleans, characters, and their NULL values.
• Time types: dates, times, time zones, date parts, precision, and NULL values.
• Custom handlers: use a field handler for entity writes and reads.
• JSON serialization: Map, List, Set, Bean, and NULL conversion.
• Array types: binding, reading, updating, and NULL round trips.

See Vector Operations for vector type mapping and search support.