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?

[AnnWorley · Accepted solution]

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