Characters like ï show as question marks in Confluence 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.PNGmyini2.PNG

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

coding.PNG

Any ideas on how to solve these character problems?

Thanks.

 

 

 

 

1 answer

0 vote

Hello Martijn,

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

Thank you!

Kind Regards,
Shannon

Hi Shannon,

Yes, it's already been set by default:

 tomcat.PNG

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

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.

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Sarah Goff-Dupont
Published 2 hours ago in Confluence

Think you know shares vs. @mentions in Confluence? Take this collab quiz.

To anyone who doubts that Atlassians are a little too obsessed with collaboration, and tools related thereto, let me describe a recent discussion we had (which took place on our internal Confluence, ...

36 views 2 3
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