Receiving "The database is not using Unicode. Crucible requires that the database uses a UTF8 encoding to support internalization".

I am receiving this error when I attempt to test the Fisheye connection, even though I unchecked the Crucible option during the initial setup.

I setup a mySQL database and user as seen below. The SQL database is running on a separate server from the Fisheye install.

CREATE DATABASE fish_db character set utf8;

CREATE USER 'fishdbuser'@'%' IDENTIFIED BY 'passwd';


On the Database Configuration page my settings are:

Type: MySQL

Driver Location: Bundled

URL: jdbc:mysql:

User Name: fishdbuser

Password: passwd

Minimum Pool Connections: 5

Maxiumum Pool Connections: 20

Parameters: useUnicode=true



I've logged into the SQL server and performed the following with success:

use fish_db;

show databases;


| Database |


| information_schema |

| crowd_db |

| fish_db |

| jira_db |

| mysql |


As you can see, I have both jira and crowd databases working from this same instance. I don't understand why Crucible is even being considered when I unchecked the box for the Crucible setup.

I've dropped the database and user a few times and recreated, but that hasn't resolved the issue. I've flushed the privileges as well, but nothing seems to work.

2 answers

1 accepted

Use collation utf8_bin for the database and it should work.

Hi All,

I am getting the same error for MSSQL server 2008. I have given connectionCollation='SQL_Latin1_General_CP1_CI_AS' but same error.

Can any one please guide what are the require parameters need to defined for SQLSERVER2008 connection?



Suggest an answer

Log in or Join to answer
Community showcase
Alexey Matveev
Published Saturday in Jira

How to run Jira in a docker container

Everything below is tested on Ubuntu 17.10. I prefer to use Jira in a docker container because: 1. I can install Jira with a couple of commands. 2. I can start and stop Jira just by starting and s...

155 views 3 7
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot