collation error.

[f-jack]

Hi,
Upgrading our servers to v5.0.16, we are experiencing collation problems with QB. QB has the character_set_connection set internally to utf8, but it causes problems, and there is no way to change that value. The error message is:

Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (latin1_swedish_ci,IMPLICIT) for operation 'concat', ErrorNr. 1270

The query runs w/o problem on the server, and had no problem running it with v4 MySQL servers.

The QB client setting is:

'character_set_client', 'utf8'
'character_set_connection', 'utf8'
'character_set_database', 'latin1'
'character_set_results', 'utf8'
'character_set_server', 'latin1'
'character_set_system', 'utf8'
'collation_connection', 'utf8_general_ci'
'collation_database', 'latin1_swedish_ci'
'collation_server', 'latin1_swedish_ci'

The server side client setting is: -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --