My Oracle Support Banner

Error: 1253 COLLATION '%s' is not valid for CHARACTER SET '%s' (Doc ID 1023440.1)

Last updated on APRIL 15, 2020

Applies to:

MySQL Server - Version 5.0 to 5.7 [Release 5.0 to 5.7]
All Platforms


 To understand Error 1253, first consider some background information about character sets and collations.  A character set comprises each symbol used and it's numeric encoding. Collations are rules that determine how these symbols are compared to each other. MySQL supports many different character sets and collations, so sometimes the above error will be seen.


Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.