MariaDB Error 1273: Unknown Collation Specified

📋

Description

MariaDB Error 1273 occurs when the database encounters a collation name that it does not recognize or support. This typically happens during database creation, table alteration, or when importing data with a specified collation that is not available on the current MariaDB server instance.

💬

Error Message

Unknown collation: '%s'

🔍

Known Causes

4 known causes

⚠️

Unsupported Collation Version

The specified collation might exist in other versions but is not supported by the current MariaDB server instance.

⚠️

Typo or Misspelling

The collation name contains a typo or is misspelled, preventing MariaDB from recognizing it.

⚠️

Missing Character Set/Collation Package

The required character set or collation package for the specified collation is not installed or enabled on the MariaDB server.

⚠️

Import from Different Environment

Importing a database dump from a server with different collation support can lead to this error if the specified collation is absent in the new environment.

🛠️

Solutions

Coming Soon

Detailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:

General Troubleshooting Tips

Check the error message carefully for specific details
Review recent changes that might have caused the error
Search for the exact error code in the official documentation
Check log files for additional context
Try restarting the application or service

Find Help

Stack Overflow Google Search Official Docs

🔗

Related Errors

5 related errors