Characters in Confluence don't show correctly

Dear All,

we moved our Confluence to another server some weeks ago. Since that all the non-English special characters didn't "survive" the move: there are question-mark ("?") everywhere.

In page contents e.g. title, contents, comments we are able to correct these errors but what could we do if the personal space name contains these "?" marks? See pic!

Thanks for your help!

Cheers,

Rumi

4 answers

1 accepted

1 vote
Peter Koczan Atlassian Team Jun 18, 2013

Hi,

Very likely this is an encoding related problem. Can you try the debugging steps in the following article: https://confluence.atlassian.com/display/DOC/Troubleshooting+Character+Encodings

Can you let me know the database type you use?

Kind regards,

Peter

Hi Peter,

we have MySQL. Thanks for the hont!

Let me check.

Rumi

0 vote
Peter Koczan Atlassian Team Jun 19, 2013

Hi,

Can you run the following queries against your database and let me know the results (replace your database name accordingly):

use database_name;

SELECT TABLE_SCHEMA,
       TABLE_NAME,
       CCSA.CHARACTER_SET_NAME AS DEFAULT_CHAR_SET,
       COLUMN_NAME,
       COLUMN_TYPE,
       C.CHARACTER_SET_NAME
  FROM information_schema.TABLES AS T
  JOIN information_schema.COLUMNS AS C USING (TABLE_SCHEMA, TABLE_NAME)
  JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY AS CCSA
       ON (T.TABLE_COLLATION = CCSA.COLLATION_NAME)
 WHERE TABLE_SCHEMA=SCHEMA()
   AND C.DATA_TYPE IN ('enum', 'varchar', 'char', 'text', 'mediumtext', 'longtext')
 ORDER BY TABLE_SCHEMA,
          TABLE_NAME,
          COLUMN_NAME;

use database_name;

status;

Thanks,

Peter

Many thanks Peter!

r

0 vote
Peter Koczan Atlassian Team Jun 19, 2013

Did any of the fixes on the encoding page work?

No, the query didn't work because the encoding went wrong before moving to the DB.

The tables have the correct encoding but the data is wrong in them.

0 vote
Peter Koczan Atlassian Team Jun 19, 2013

Hi,

If you open a support ticket with us at http://support.atlassian.com I can check the results of the query and additional settings in your instance then advice on possible fixing of the encoding.

Cheers,

Peter

Hi,

thank you!

May I attach a support zip to the ticket?

Cheers,

Rumi

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
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

380 views 21 10
Join discussion

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