Error Code Portal
PostgreSQLPostgreSQLError code

42P21

collation mismatch

Alternative forms: collation_mismatch

What does this code mean?

Code 42P21 · An issue reported by PostgreSQL.

Official explanation · Original text

collation_mismatch (Class 42 — Syntax Error or Access Rule Violation)

Troubleshooting and diagnostic links

First check that the document's product, version, and environment match your situation.

Source and terms of use

PostgreSQL: Documentation: 18: Appendix A. PostgreSQL Error Codes ↗

Creator: PostgreSQL Global Development Group; The Regents of the University of California
License: PostgreSQL License
Checked on: 2026-11-12

Modifications: English prose extracted; whitespace normalized; Korean context and classified official links added. Python code examples not redistributed.

Source details · Original licenses and notices