nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

PeterKoczan

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

All comments

PeterKoczan

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,

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!

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,

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

confluence-administration