View Shows Wrong Results When We Alter The Table It Selects - Cannot convert string
(Doc ID 2875404.1)
Last updated on JUNE 13, 2022
Applies to:MySQL Server - Version 8.0 and later
Information in this document applies to any platform.
View shows wrong results when we alter the table it selects
There is an issue with a view, that shows wrong results when the referenced table is altered. It doesn't happen in version 5, but it does in version 8
It looks like the view is recreated too, reading the definition somewhere, and not converting the charset
Until MySQL 8.0 the default character set in MySQL was Latin-1 (named latin1). So, in MySQL 8.0 the change was made to make utf8mb4 the default character set.
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