Configuring UTF8 Character Set for MySQL

Skip to end of metadata
Go to start of metadata
You are viewing documentation of TeamCity 6.5.x, which is not the most recent released version of TeamCity. Please refer to the listing to choose another version.
Search

Searching TeamCity 6.5.x Documentation

Table of Contents

To create a MySQL database which uses the utf8 character set:

  1. Create a new database:
  2. Open <TeamCity data directory>/config/database.properties, and add the characterEncoding property:

To change the character set of an existing MySQL database to utf8:

  1. Shut the TeamCity server down.
  2. Dump the database data to the file dump_data.sql:
  3. Dump the database schema to the file dump_schema.sql:
  4. Edit dump_schema.sql. Remove DEFAULT CHARSET=<some charset> from the table and column definitions.
  5. Create a new database with uft8 as the default character set:
    CREATE DATABASE <new database name> DEFAULT CHARACTER SET utf8;
    
  6. Import dump_schema.sql into the new database:
    mysql -u<user> -p<pass> <new database name> <dump_schema.sql
    
  7. Import dump_data.sql into the new database:
    mysql -u<user> -p<pass> <new database name> <dump_data.sql
    
  8. Modify <TeamCity data directory>/config/database.properties file as follows:
    • change connectionUrl property to:
      jdbc:mysql://<host>/<new database name>
      
    • add characterEncoding property:

Labels:

server server Delete
configure configure Delete
utf utf Delete
admin admin Delete
mysql mysql Delete
Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.