Conversion of different data types conducted by Sybase CEP.
The following table shows all permitted CCL data type conversions (also known as type casting). The source datatypes are listed in the leftmost column and the destination datatypes are listed in the top row of the chart. “X” indicates that the conversion is supported; a blank space indicates that the conversion is not supported.
| Permitted Conversions | Blob | Boolean | Float | Integer | Interval | Long | String | Timestamp | XML |
| Blob | X | ||||||||
| Boolean | X | ||||||||
| Float | X | X | X | X | X | ||||
| Integer | X | X | X | ||||||
| Interval | X | X | X | ||||||
| Long | X | X | X | X | X | ||||
| String | X | X | X | X | X | X | X | X | |
| Timestamp | X | X | X | ||||||
| XML | X |
The following table shows the implicit (automatic) conversions Sybase CEP Engine performs when necessary. The source datatypes are listed in the leftmost column and the destination datatypes are listed in the top row of the chart. “X” indicates that the conversion is supported; a blank space indicates that the conversion is not supported. Note that the Sybase CEP compiler generates a warning message whenever it performs implicit type casting to or from a String:
| Implicit Conversions | Blob | Boolean | Float | Integer | Interval | Long | String | Timestamp | XML |
| Blob | X | ||||||||
| Boolean | X | ||||||||
| Float | X | ||||||||
| Integer | X | X | X | ||||||
| Interval | X | ||||||||
| Long | X | X | |||||||
| String | X | X | X | X | X | X | X | X | |
| Timestamp | X | ||||||||
| XML | X |