My Oracle Support Banner

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

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