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]
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!