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 multiple implicit non-default collations. Use COLLATE function to set the collation explicitly.