Hey guys.
I've just installed confluence on my own server with MySQL as database.
Database was created with
create database confluence character set utf8 COLLATE utf8_bin;
Polish is set to be main language. However, I am experiencing strange issue with saving and displaying polish diacritic chars.
All page templates after inserting has "??" in place of polish chars like ó ż ę ć. However, in settings of given template, everything is ok.
Page titles are bugged – in editing mode, everything is fine. On reading mode, I see "??" in place of these chars.
Manually entered page content is... random.
First page preview after saving page is broken. As above, polish chars doesn't work. However, the moment I hit refresh - its fixed.
Most of the system messages work properly, however in some places polish chars are also broken.
In audit log in admin console, some string like "Usuni?to zezwolenie dotycz?ce przestrzeni" are broken. Instead of "?" should be "ę".
I've no clue what else can be done. It is already my second attempt to use confluece in my company. Last time, almost one year ago I experienced exactly same problem. Tried to google it, playing around with database collation with no luck.
// problem fixed.
adding `useUnicode=true&characterEncoding=UTF8` to connection url string solved problem.
Maciej
Can you please make sure to add your resolution as an answer and accept it so it can help others to know the issue is resolved and how?
Thank you!
Shannon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.