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.

Symptoms

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
 





Changes

 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.

Cause

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
Symptoms
Changes
Cause
Solution
References


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