default collation_connection
Hi everyone.
Recently changed the DB server collation from utf8mb4_general_ci to utf8mb4_unicode_ci, however, when accessing the DB via a workbench connection I get this:
collation_connection = utf8mb4_general_ci
collation_database = utf8mb4_unicode_ci
collation_server = utf8mb4_unicode_ci
It correctly receives everything from the server, however, it keeps the utf8mb4_general_ci.
This is corrected by running this: SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
What I need is to avoid this execution every time I open a new connection, as it is possible that I forget to execute this query and when interacting with the DB it is very possible to generate errors.
I have the version 8.0.41 build 4802116 CE
I have already tried to modify the option Manage Server Connections>“My connection”>Advanced>Others = sessionVariables=collation_connection=utf8mb4_unicode_ci
But this has had no effect.
Do you know how I can solve this and leave by default this collation utf8mb4_unicode_ci?
Subject
Views
Written By
Posted
default collation_connection
59
February 27, 2025 02:20PM
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.