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
Collate Problem when upgrading the server
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Collate Problem when upgrading the server
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.Zero-G. wrote: 'collation_database', 'latin1_german1_ci'
'collation_server', 'utf8mb4'