Previous Topic: -20 - BAD SYNTAX: description WHEN THE ERROR OCCURRED, THE SYNTAX BELOW HAD BEEN PARSED: statementNext Topic: -24 - VIEWS CONTAINING FUNCTIONS OR GROUP BY CANNOT BE JOINED

SQL Codes › SQL Return Codes -1 through -999 › -21 - DEFAULT CHARACTER LITERAL TOO LONG

-21 - DEFAULT CHARACTER LITERAL TOO LONG

Reason:

In a CREATE TABLE or ALTER TABLE statement, you specified (as the default value for a column) a character string which is longer than the column definition.

The SQLSTATE that equates to this SQL return code is 54S01.

Action:

Enlarge the column definition or specify a string which fits in the column.