Is it possible to set collation and charset to MySQL service in Bitbucket Pipeline?

mullermartin

I use MySQL database in Bitbucket build pipeline defined like this:

definitions:
services:
mysql:
image: mysql:5.7
variables:
MYSQL_DATABASE: testbase
MYSQL_ROOT_PASSWORD: pass

But it use wrong (default) charset and collation. I need UTF-8 to get rid of exceptions like:

SQLException: Incorrect string value: '\xC5\x88' for column 'city' at row 1

Is there a way to fix it in bitbucket-pipelines.yml? In a standard Docker setup I can fix it this way:

database:
image: mysql:5.7
environment:
MYSQL_DATABASE: testbase
MYSQL_ROOT_PASSWORD: pass
command: [ 'mysqld', '--character-set-server=utf8', '--collation-server=utf8_general_ci' ]

 

Theodora Boudale

Hi @mullermartin,

At the moment I'm afraid that it is not possible to pass a command to a Docker service container, like in the example you included.

We have a feature request about this in our issue tracker:

• https://jira.atlassian.com/browse/BCLOUD-15997

If you'd be interested in this, I would suggest that you add your vote in that request (by selecting the Vote for this issue link) as the number of votes helps the development team and product managers better understand the demand for new features. You are more than welcome to leave any feedback, and you can also add yourself as a watcher (by selecting the Start watching this issue link) if you'd like to get notified via email on updates.

In the meantime, a way to work around this issue would be to create a custom Docker image (based on the official mysql image) that sets your own CMD value, or supports environment variables for settings like these.

Kind regards,
Theodora