Datatype Compatibility

The SAP ASE server generates an error message when it attempts to insert a default value that is not compatible with the column’s datatype.

For example, if you bind a character expression such as “N/A” to an integer column, any insert that does not specify the column value fails.

If a default value is too long for a character column, the SAP ASE server either truncates the string or generates an exception, depending on the setting of the string_rtruncation option. See the set command.