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; } } }

Confluence - Korean letters are shown as '?????' only after save

Jude Kim

After I create new page in Korean, those letters are changed to "?????".

It was okay in the editor before save, and also okay if I edit the page.

I changed default language to Korean from English, but it had no effect.

MySQL is being used, and utf8 was set during MySQL setting up.

Could anyone help me about it?

Accepted answers

AnnWorley

Hi Jude,

I found this knowledge base article that fits your description of the issue: Characters appear as question marks using MySQL

Please run the diagnostic query from that page to see if inbound connections are encoded properly:

SHOW VARIABLES LIKE 'character\_set\_%';

The article has a resolution listed in case you find the character_set_server variable is not set to utf8.

Thanks,

Ann

All comments

AnnWorley

Hi Jude,

I found this knowledge base article that fits your description of the issue: Characters appear as question marks using MySQL

Please run the diagnostic query from that page to see if inbound connections are encoded properly:

SHOW VARIABLES LIKE 'character\_set\_%';

The article has a resolution listed in case you find the character_set_server variable is not set to utf8.

Thanks,

Ann

Jude Kim

Hi Ann,

Thanks a lot!

I've studied the link and those related you helped me with, and found out that

"Specify the default character set to be UTF-8" in the page :

https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

should have been translated as 'do that in my.ini',

[mysql]

...
default-character-set=utf8

...

I think it'll be good if the page can be modified, only if I'm right.

Once again, thanks a lot!

Jude

AnnWorley

Hi Jude,

I think the authors of the doc meant it to be done in my.ini or my.cnf depending on OS:

Edit the my.cnf file (my.ini on Windows operating systems) in your MySQL server. Locate the [mysqld]section in the file, and add or modify the following parameters:
(Refer to MySQL Option Files for detailed instructions on editing my.cnf and my.ini.)
Locate the [mysqld]section in the file, and add or modify the following parameters:
Specify the default character set to be UTF-8:
[mysqld]
...
character-set-server=utf8
collation-server=utf8_bin
...

Thanks,

Ann

Welcome!

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

Quick Links

Find more posts tagged with

confluence

encoding

language

character