TeamCity 2019.1 Help

Configuring UTF8 Character Set for MySQL

To create a MySQL database which uses the utf8 character set:
  1. Create a new database:

    create database <database_name> character set UTF8 collate utf8_bin
  2. Open <TeamCity data directory>/config/database.properties, and add the characterEncoding property:

    connectionProperties.characterEncoding=UTF-8
To change the character set of an existing MySQL database to utf8:
  1. Shut the TeamCity server down.

  2. From the <TeamCity Home>/bin directory, export the database using the maintainDB tool:

    maintainDB backup -D -F database_backup

    More details on this backup are here.

  3. Create a new database with utf8 as the default character set, as described above.

  4. Modify the <TeamCity data directory>/config/database.properties file by changing the connectionUrl property to:

    jdbc:mysql://<host>/<new_database_name>
  5. Import data the new database:

    maintainDB restore -D -F database_backup -T <TeamCity data directory>/config/database.properties
  6. Start the TeamCity server.

Last modified: 11 June 2019