Collate Problem when upgrading the server

[Zero-G.]

Hey
At the Moment I am using mySQL Server 5.5 for my Software.
I connect via Connection String without specifing any collation. Everything works fine

For testing purposes I installed Version 8 of mySQL Server and here, the collation does not work correct anymore.
When I explicit specify UTF8 within the Connection string, than it works fine.


The interesting Thing is, that when I run:
SHOW VARIABLES LIKE 'collation%';

On Server 5.5 I get:
'collation_connection', 'utf8_general_ci'
'collation_database', 'latin1_german1_ci'
'collation_server', 'latin1_german1_ci'

On Server 8 I get
'collation_connection', 'utf8_general_ci'
'collation_database', 'latin1_german1_ci'
'collation_server', 'utf8mb4'

I can set the collation_server on mySQL 8 to "latin_german1_ci", but the Problem itselfs stays.

Was / is there internal any difference, when Connection to 5.5 or 8?

THX for advise - Harald

[Pinturiccio]

'collation_database', 'latin1_german1_ci'
'collation_server', 'utf8mb4'

These two parameters are set on the server side, not on the client side. On the client side you can set only the collation_connection parameter, for example, when you explicit specify UTF8 within the connection string.