Map the datatypes provided by Replication Server to the datatypes used by Event Stream Processor.
Replication Server supports other databases (such as Oracle, Microsoft SQL Server, and IBM DB2 UDB) and the datatypes that they use. It provides data to ESP using the datatypes shown in the mapping table. These datatypes are also used by Adaptive Server Enterprise .
Replication Server also handles the different character sets used by supported databases. It provides data to the adapter in Unicode. ESP has Unicode (UTF-8) support: it is turned off by default and may be turned on for individual projects. See the Project Configurations topic in the Studio Users Guide for details.
| ESP Datatype | Replication Server Datatypes |
|---|---|
| integer | smallint, tinyint, int, bit |
| timestamp | datetime, time |
| date | date, smalldatetime |
| long | bigint, unsigned bigint, unsigned int, unsigned smallint |
| string | binary, char, unichar, nchar, nvarchar, varbinary, univarchar, varchar, timestamp |
| float | numeric, float, real |
| money | money, smallmoney |
| bigdatetime | bigdatetime (ASE15.7 or later) |
| boolean | bit |
| binary | varbinary |