Foreign Key (FK) Constraint Name Appears As ? Character
(Doc ID 1550330.1)
Last updated on APRIL 15, 2020
Applies to:MySQL Server - Version 5.1 to 5.6 [Release 5.1 to 5.6]
Information in this document applies to any platform.
The symptom is that SHOW CREATE TABLE does not properly display Foreign Key (FK) Constraint names anymore.
Upgrading to 5.1.69, 5.5.31, 5.6.11 introduces this problem, where if any non-latin1 characters appeared in the Constraint name of a FK, SHOW CREATE TABLE will replace them with ? characters.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document