Datatype Mapping: Microsoft SQL Server Database
Mapping between Event Stream Processor datatypes and Microsoft SQL Server 2008 R2 datatypes.
| Event Stream Processor Datatype | SQL Datatype |
|---|---|
| integer | int |
| long | bigint |
| float | float |
| seconddate | datetime |
| string | varchar(n) |
| money | money |
| msdate | datetime2 |
| boolean | smallint or bit (Does not support null values) |
| money1 | numeric(19,1) |
| money2 | numeric(19,2) |
| money3 | numeric(19,3) |
| money4 | numeric(19,4) |
| money5 | numeric(19,5) |
| money6 | numeric(19,6) |
| money7 | numeric(19,7) |
| money8 | numeric(19,8) |
| money9 | numeric(19,9) |
| money10 | numeric(19,10) |
| money11 | numeric(19,11) |
| money12 | numeric(19,12) |
| money13 | numeric(19,13) |
| money14 | numeric(19,14) |
| money15 | numeric(19,15) |
| interval | bigint |
| bigdatetime | datetime2 |
| binary | varbinary(n) |