Sybase data type

Data Types

Different data types are assigned to columns in a CCL stream.

Each value that Sybase CEP Engine manipulates has a data type. When you define a data stream in CCL, you must specify a data type for each of its columns. Note that Sybase CEP Engine can implicitly convert some data types to the correct type for a column. You can also use conversion functions to generate the correct data type.

The following table summarizes CCL data types (note that all data types can also be Null):

Data Type	Description
BLOB	Binary Large Object. BLOB columns contain varying amounts of data as a sequence of bytes. Maximum size is platform-dependent, but no less than 65535 bytes. Sybase CEP Engine supports comparison between BLOBs, by comparing the same byte from each BLOB value in sequence. If all bytes are identical, the two values are considered to be equal. If the two BLOBs contain different values, the smaller value is the one with a smaller value in the first byte that differs.
BOOLEAN	TRUE or FALSE.
FLOAT	A 64-bit floating point number with binary precision. The maximum number for this type corresponds to IEEE standards.
INTEGER	A 32-bit integer.
INTERVAL	Represents an integer number of microseconds between two timestamps, using 64 bits of precision.
LONG	A 64-bit integer.
STRING	Variable-length character string, with byte values encoded in UTF-8. Maximum string length is platform-dependent, but no less than 65535 bytes.
TIMESTAMP	Date and time, with a precision of microseconds
XML	A sequence of XML element trees (a forest). Maximum size is platform-dependent, but no less than 65535 bytes.

The following table lists the minimum and maximum values for numeric data types:

Data Type	Minimum/Maximum
FLOAT	Approximately 16 significant digits.
INTEGER	-2147483648 to +2147483647 (-231 to 231-1). Overflow wraps silently.
INTERVAL	-99999999 days 23:59:59.999999 to +99999999 days 23:59:59.999999.
LONG	-9223372036854775808 to +9223372036854775807 ( -263 to 263-1). Overflow wraps silently.
TIMESTAMP	1970-01-01 00:00:00.000000 to 2099-12-31 23:59:59.999999. Timestamp values between 0001-01-01 00:00:00.000000 and 1969-12-31 23: 59:59.999999 and between 2100-01-01 00:00:00.000000 and 9999-12-31 23: 59:59.999999 are also valid, but may result in errors related to leap years and daylight savings time. Timestamps prior to midnight January 1, 1970 are represented as negative numbers.