COLLATION_MISMATCH error class

  • Article

SQLSTATE: 42P21

Could not determine which collation to use for string functions and operators.

EXPLICIT

Error occurred due to the mismatch between explicit collations: [<explicitTypes>]. Decide on a single explicit collation and remove others.

IMPLICIT

Error occurred due to the mismatch between implicit collations: [<implicitTypes>]. Use COLLATE function to set the collation explicitly.