Character set/collation-related problems

To fix a problem, perform the following steps:

1. Create a new database with the appropriate character set and collation. For the database-specific information, see PostgreSQL, MySQL
   MS SQL. If you are using MySQL or MS SQL, we recommend using the case-sensitive collation to avoid issues with agents on Unix-like OS.
2. Copy the current <TeamCity Data Directory>/config/database.properties file, and change the database references in the copy to the newly created database.
3. Stop the TeamCity server.
4. Use the maintainDB tool to migrate to the new database:

   maintainDB migrate [-A <path-to-data-dir>] -T <new-database-properties-file>

   Depending on the size of your database, the migration may take from several minutes to several hours. For more information on the maintainDB tool, see this section.

5. Upon the successful completion of the database migration, the maintainDB tool should update the <TeamCity Data Directory>/config/database.properties file with references to the new database. Ensure that the file has been updated. Edit the file manually if the tool fails to do it automatically.
6. Start the TeamCity server.