Error
Error Code:
1273
MySQL Error 1273: Unknown Collation Specified
Description
Error 1273 occurs when MySQL encounters a collation name that it does not recognize or support. This typically happens during database or table creation, alteration, or when connecting to a database with an unsupported collation setting.
Error Message
Unknown collation: '%s'
Known Causes
4 known causesTypo or Misspelling
The specified collation name contains a typo or is misspelled, preventing MySQL from finding a matching definition.
Unsupported MySQL Version
The collation was defined in a different MySQL version or is not supported by the current MySQL server instance.
Missing Custom Collation
A custom collation is referenced but has not been correctly installed or registered with the current MySQL server.
Incorrect Character Set Pairing
The collation is specified for a character set that it does not belong to, leading to an invalid combination.
Solutions
Coming SoonDetailed 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