Mapping between Event Stream Processor datatypes and SAP Sybase IQ datatypes.
| ESP Datatype | SAP Sybase IQ Datatype |
|---|---|
| integer | INT |
| long | BIGINT |
| float | FLOAT |
| date | TIMESTAMP |
| string | VARCHAR |
| time | TIME |
| money | NUMERIC(19,4) |
| timestamp | TIMESTAMP |
| boolean | Smallint or BIT (no nulls) |
| money(s) | NUMERIC(19,s) |
| decimal(p,s) | NUMERIC(p,s) |
| interval | BIGINT |
| bigdatetime | TIMESTAMP |
| binary | VARBINARY |