MySQL default-character-set=utf8
Hi
We have a TeamCity 5.1.4 instance configured with a MySQL database.
We would like to use the same MySQL server instance to host a FishEye/Crucible database, however the instructions for this http://confluence.atlassian.com/display/FISHEYE/Migrating+to+an+External+Database state that we must add 'default-character-set=utf8' to the my.cnf to ensure 'Server Characteristics' and 'Db Characteristics' are both 'utf8'.
Currently, mysql status reports the following...
mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.67, for suse-linux-gnu (x86_64) using readline 5.2
Connection id: 231
Current database:
Current user: devtools@localhost
SSL: Not in use
Current pager: less
Using outfile: ''
Using delimiter: ;
Server version: 5.0.67 SUSE MySQL RPM
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 39 days 18 hours 37 min 46 sec
Please can you confirm that this change will not cause an issue for TeamCity.
Cheers
Daniel
Please sign in to leave a comment.
Yes, you can use utf8 for TeamCity.
http://confluence.jetbrains.net/display/TCD5/Configuring+UTF8+Character+Set+for+MySQL