Each column in a schema must have a datatype. The datatype defines the kind of value that each column may contain.
The following table lists the datatypes available in Sybase CEP.
|
Datatype |
Description |
|---|---|
|
Boolean |
A value of TRUE or FALSE. |
|
Integer |
A numeric value representing a signed 32-bit binary integer. Values range from -2,147,483,648 to 2,147,483,647. |
|
Long |
A numeric value representing a signed 64-bit binary integer. Values range from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807. |
|
Float |
A numeric value representing a signed 64-bit IEEE floating-point number. Values range approximately between -10+/-308 to +10+/-308. |
|
String |
A character string value representing a variable-length string. Maximum string length is system-dependent, but is always at least 65,535 characters (and may be much greater). |
|
Timestamp |
A 64-bit time value representing a date (year, month, day) and time (hours, minutes, seconds and microseconds). This datatype is useful for storing precise time values. Row timestamps are always implicitly assigned the TIMESTAMP datatype. |
|
Interval |
A time value representing a 64-bit integer that contains a number of microseconds. This number is typically used to store the difference in time between two TIMESTAMPs. |
|
XML |
A data item representing an XML tree or forest. An XML column value must contain correctly constructed XML, but is not verified against any specific XML DTD or XML Schema. |
|
Blob |
A Binary Large Object representing a long unconstrained binary string of data, which may include, in addition to regular string values, ASCII NULLs, control characters and other binary values. |
For a full listing of available datatypes and their limitations and requirements, please see the Sybase CEP CCL Reference.