Bamboo build plans don't display utf chars

[Deleted user]

Users with ? in Fullname.

How to fix this problem?

This link did not fix the problem https://confluence.atlassian.com/bamkb/how-to-change-the-wrong-encoding-in-bamboo-that-is-causing-crashes-or-characters-to-display-incorrectly-318670134.html

Only in Bamboo, not in JIRA, Confluence or Bitbucket.

[Daniel Santos]

Hi @[deleted]

I'll need more details to try helping you with this one.

• Can you share what is the database type used with the specific version?
• Please share as well the collation used and any extra DB configuration you may have manually set for the Bamboo data.

When configuring Bamboo external DB we need to follow the following document:

• Connecting Bamboo to an external database - Atlassian Documentation
• Supported platforms 6.6.x - Atlassian Documentation

I'll wait for your comments.

[Deleted user]

Database details

Driver nameMySQL Connector JavaDriver class namecom.mysql.jdbc.DriverDriver versionmysql-connector-java-5.1.47 ( Revision: fe1903b1ecb4a96a917f7ed3190d80c049b1de29 )Database URLjdbc:mysql://localhost/db_bamboo?autoReconnect=trueUser namebamboo@localhostHibernate dialectorg.hibernate.dialect.MySQL5InnoDBDialect

Where do I found collation information in Bamboo?

[Daniel Santos]

Hi @[deleted]

I don't think Bamboo saves this information anywhere, but you can get it directly from your DB. This is one of the articles you can use (not from Atlassian though): How to Show the Collation of a Database in MySQL.

I think the issue you are facing is caused by the missing support for utf8mb4.

• [BAM-18703] Support MySQL utf8mb4 encoding

There is also an Atlassian article talking about a similar problem with MySQL: Branch names with emoji or 4 byte UTF8 characters create hundreds of plan branches in Bamboo.

[Victor Debone]

Hello @[deleted]

What is the Bamboo version that you are having issue with?

Victor

[Deleted user]

Version 6.6.3.