Messages associated with SQLSTATE 42804

This topic lists the messages associated with the SQLSTATE 42804.

SQLSTATE 42804 description

DATATYPE_MISMATCH

Messages associated with this SQLState

Error messages

ERROR 2217: Argument string must be type float, not type string
ERROR 2218: Argument string must be type integer, not type string
ERROR 2222: Argument string must not return a set
ERROR 2224: Argument of string must be type boolean, not type string
ERROR 2225: Argument of string must not return a set
ERROR 2231: Array assignment requires type string but expression is of
            type string
ERROR 2232: Array assignment to "string" requires type string but expression
            is of type string
ERROR 2234: Array subscript must have type integer
ERROR 2358: Cannot assign to field "string" of column "string" because its
            type string is not a composite type
ERROR 2527: Cannot subscript type string because it is not an array
ERROR 2630: Column "string" is of type string but default expression is of
            type string
ERROR 2631: Column "string" is of type string but expression is of type string
ERROR 2846: Could not determine actual result type for function "string"
            declared to return type string
ERROR 3429: For 'string', types string and string are inconsistent
ERROR 3545: Index expression may not return a set
ERROR 3801: IS DISTINCT FROM requires = operator to yield boolean
ERROR 3943: Mismatched types in VALUES LESS THAN expressions
ERROR 4284: Operator string must not return a set
ERROR 4285: Operator string must return type boolean, not type string
ERROR 4317: Parameter $value of type string cannot be coerced to the expected
            type string
ERROR 4803: Subfield "string" is of type string but expression is of type string
ERROR 7221: Argument of type string must be type boolean, not string
ERROR 7222: Argument of type string must be type boolean, not type string
ERROR 7309: Column "string" is of type string but set using expression is of
            type string
ERROR 7929: Column to be added/refreshed is of type string but
            default/set-using expression is of type string
ERROR 9799: Cannot subscript an empty array
ERROR 9801: Cannot subscript type string with value subscript levels
ERROR 9908: Cannot subscript column "string" of type string because it is not
            an array
ERROR 10202: Operator string not supported for complex types with arrays
ERROR 10220: Values being compared do not have the same schema

Warning messages

WARNING 6480: Column "string" is of type string but expression in Access
              Policy is of type string. It will be coerced at execution
              time