Collate Problem when upgrading the server
Posted: Mon 25 Feb 2019 15:30
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
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