Forums

Problem with letters with diacritics (ěščřžýáíé)

Permalink
Hi everyone, I have one question on someone. My web page worked all the time good long time. But now, after half an year I would like to add some new pages and when I am writting some words with czech special letter - with diacritics (ěščřžýáíé) it makes my problem. Its displayed like questionmark. I understand that there is some problem with some code language...but all the time it was working fine and suddenly not.
Could somebody help me with this problem? Many thanks before!

Vojta

1 Attachment

 
Mainio replied on at Permalink Reply
Mainio
Have you moved your site to a different server during this time? Or has your hosting provider done some changes regarding the database server?

This is most likely caused by a database character set mismatch.

We recently had this on one site (due to moving to a new environment) and made a script to fix it. I just put it to github so take a look at it:
https://github.com/ahukkanen/c5_charset_fix...

After running it, you'll need to re-enter the content that currently has question marks.

AND REMEMBER TO TAKE A DATABASE BACKUP PRIOR TO RUNNING THAT!

Antti / Mainio
novakv replied on at Permalink Reply
Great! Thank you very much! It workes. ;-)