Characters in Confluence don't show correctly

Rumceisz June 18, 2013

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
Answer accepted
PeterKoczan
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 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

Rumceisz June 19, 2013

Hi Peter,

we have MySQL. Thanks for the hont!

Let me check.

Rumi

0 votes
PeterKoczan
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 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

Rumceisz June 20, 2013

Hi,

thank you!

May I attach a support zip to the ticket?

Cheers,

Rumi

0 votes
PeterKoczan
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 19, 2013

Did any of the fixes on the encoding page work?

Rumceisz June 19, 2013

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 votes
PeterKoczan
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 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

Rumceisz June 19, 2013

Many thanks Peter!

r

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events