Polish characters after upgrate to MySQL

[sokolman]

Hello,

I've change database to production, set to UTF-8 and after upgrade and restore from backup polish special chars are changed to '?'. My confluence version is 7.0.3. Anyone have some idea what to do?

[Bastian Stehmann]

Ho @sokolman ,

Welcome to the community. 

Can you check that you have set the encoding right on server, database and table level.

Additional, this kb article might help you getting closer to the issue.

https://confluence.atlassian.com/doc/troubleshooting-character-encodings-167194.html

[sokolman]

Hello,

This troubleshooting pass the test, but polish special chars are missing. I've checked data base : schema and tables are in utf-8, utf-8bin.

[Bastian Stehmann]

Did you also check the server configuration in your my.cnf?

I once had a similar issue and then it was only the server config missing, if I remember correct.

[sokolman]

It works! Thanks

I've added this to my.cnf

[client]default-character-set=utf8

[mysql]default-character-set=utf8


[mysqld]collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'character-set-server = utf8

[Bastian Stehmann]

Great to hear that.

[Lenin Raj]

Hi @sokolman 

Can you check if the actual database content is still in Polish or also changed to '?'. It could have been lost during the backup/restore process.

[sokolman]

Hi, Thanks for answer. New content also have '?'.