Datatype Mapping for the Sybase IQ Adapter

Event Stream Processor datatypes map to Sybase IQ datatypes.

If required, you can create a table in Sybase IQ to map Event Stream Processor datatypes to other compatible Sybase IQ datatypes. The datatype mapping below is default mapping.

Note: The date and timestamp Event Stream Processor datatypes are compatible only with the datetime Sybase IQ datatype.

Event Stream Processor Datatypes	Sybase IQ Datatypes
`bigdatetime`	`timestamp`
`binary`	`binary`
`boolean`	`varchar(5)`
`date`	`datetime`
`float`	`float`
`integer`	`integer`
`interval`	`bigint`
`long`	`bigint`
`money`	`decimal(38,4)`
`money(n)`	`decimal(38,n)`
`string`	`varchar(n)`
`timestamp`	`datetime`