SAND CDBMS SQL Reference Guide
SAND CDBMS SQL Database Objects and Language Elements

 

Previous Topic:
SAND CDBMS Data Types
Chapter Index
Next Topic:
Resulting Data Types

 

SAND CDBMS Data Types


Data Type Compatibility

All SQL operations involving operands, such as value expressions, INSERTs, UNIONs, and joins, require compatibility among the operand data types. The compatible data types are as follows:

Generally, character data types are compatible with other character types, numeric data types with other numeric types, and date/time types with others of the exact same type. The exception is the BLOB data type, which is not compatible with any other type, and cannot even be compared to other BLOB instances.

One further restriction on INSERT operations is that an inserted character string cannot exceed the length of the target column data type or domain.