Pipelines - Server sent charset unknown to the client

[Deleted user]

Had some builds passing a few days ago, but today we have been getting this error even when re-running the passing builds:

“SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers”

Did something change in Pipelines? How can we set the charset of the server? Thanks!

[Deleted user · Accepted solution]

In the end we fixed this by editing bitbucket-pipelines.yml so that the PHP version we were using was php 7.1.16 and mysql version was 5.7. 

[edwin]

Hi Gillian,

If using MySQL, this might help. Set in my.cnf.

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8


[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8

 Found in this link with the same error.

[Deleted user]

Thanks, but how can we edit my.cnf in bitbucket pipelines? 

[David Pashley]

Don't use utf8 with MySQL, as it's an alias for their broken utf8mb3 encoding. Explicitly use utf8mb4 (and utf8mb4_unicode_ci)