与 SQLSTATE 42804 关联的消息

本主题列出了与 SQLSTATE 42804 关联的消息。

SQLSTATE 42804 说明

DATATYPE_MISMATCH

与此 SQLState 关联的消息

错误消息

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 6480: Column "string" is of type string but expression in Access
              Policy is of type string. It will be coerced at execution
              time