In this blog post, let’s learn about the error message “1186 Column column-name is of type column-data-type which is not compatible with the default value’s type, value-data-type.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1186 Column column-name is of type column-data-type which is not compatible with the default value’s type, value-data-type.
Reason for the Error
The value specified as the default for the column is incompatible with the type of the column.
Solution
Change either the column data type or the value for the default to be compatible types and resubmit