Collation and illegal mix
Posted by:
Nigel Gomm
Date: September 24, 2024 07:50AM
i have a 8.0.37 mysql server running on azure. The server, the database, all tables and all columns are set to character set latin1 and collate latin1_general_ci.
when i create a view with unions from a user where the session variable collation_connection is utf8mb4_0900_ai_ci the view works as it should for every other user.
if i create the view from a user where that session variable is 'latin1_general_ci' every user gets the Illegal mix of collations for operation 'UNION' error message.
Is that a bug or do i have a fundamental misunderstanding of what's going on?
Subject
Views
Written By
Posted
Collation and illegal mix
238
September 24, 2024 07:50AM
111
September 24, 2024 07:56AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.