Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.

×
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Characters like ï show as question marks in Confluence

Ictbeheer September 4, 2017 edited

I installed the dutch language pack and characters which should be ï  are shown as ? within Confluence:

questionmark.PNG

A little digging in the forums says it could have to do with character encoding settings. I have set everything up according to the manual. I also checked the results posted in this page.

I use MySQL as database and checked the status and table status. The output is looking good:mysql.PNG  

Also the JDBC connection is set to UTF8 in server.xml:

serverxml.PNG

And also in the confluence.cfg.xml:

confluencecfg.PNG

 

Within confluence settings itself also shows UTF-8:

confluence_utf.PNG

my.ini of MySQL installation settings:

myini1.PNG myini2.PNG

The results of the ./admin/encodingtestrun.action page:

coding.PNG

Any ideas on how to solve these character problems?

Thanks.

 

 

 

 

1 answer

0 votes
Shannon S
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
September 5, 2017

Hello Martijn,

Can you confirm also if your application server has the encoding per this page

Thank you!

Kind Regards,
Shannon

Ictbeheer September 5, 2017 edited

Hi Shannon,

Yes, it's already been set by default:

 tomcat.PNG

Shannon S
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
September 5, 2017

Thank you, Martijn.

There are more steps in the How to fix Collation and Character set of a MySQL Database that will show you how to drill down deeper to tables and columns.

Can you review the steps there and let us know if it helps you? 

Kind Regards,
Shannon

Ictbeheer September 7, 2017 edited

Hi Shannon,

I opened a support ticket for this issue. They told me it's a bug. They opened a bug report for me at https://jira.atlassian.com/browse/CONFSERVER-53412

I hope the issue will be addressed soon. I am really in need of a dutch version of Confluence.

Thank you for your help.

Shannon S
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
September 7, 2017

Martijn,

Thank you for letting us know that. I do hope to see that resolved for you.

Take care and Kind Regards,
Shannon

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, atlassian government cloud, fedramp, webinar, register for webinar, atlassian cloud webinar, fedramp moderate offering, work faster with cloud

Unlocking the future with Atlassian Government Cloud ☁️

Atlassian Government Cloud has achieved FedRAMP Authorization at the Moderate level! Join our webinar to learn how you can accelerate mission success and move work forward faster in cloud, all while ensuring your critical data is secure.

Register Now
AUG Leaders

Upcoming Confluence Events