Characters in Confluence don't show correctly

[Rumceisz]

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

[PeterKoczan · Accepted solution]

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]

Hi Peter,

we have MySQL. Thanks for the hont!

Let me check.

Rumi

[PeterKoczan]

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]

Hi,

thank you!

May I attach a support zip to the ticket?

Cheers,

Rumi

[PeterKoczan]

Did any of the fixes on the encoding page work?

[Rumceisz]

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.

[PeterKoczan]

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]

Many thanks Peter!

r