How to fix the wrong text coding?

localicon / 2010-09-29 22:44:48   

Hi, I have problems with punctuation in Slovak language. When I use some letters with hiccup it gives me a question mark instead. Specifically it happens with "č" and "ľ". It is visible here http://localicon.sk/index.php?/collection-2010/collection-2010/
I asked friends using Indexhibit with Slovak language, they don´t have this problem. Please, where could be the problem and what is the solution?

Vaska A / 2010-09-29 22:45:51   

Search the forum...this has been solved for ages. It's something in the datatabse you need to adjust.

localicon / 2010-09-29 22:51:53   

Please, could you be more specific? I am really an amateur in this matter. Thanks.

Vaska A / 2010-09-29 23:48:23   

More specific about searching the forum? ;)

Your host provides a tool called PHPMyAdmin. You can log into this and change:

- the database
- the tables
- the columns

From their current (incorrect) "collation" value to "utf8-general-ci". This will probably take you 20 minutes or so.

Once you have done this, try re-entering a character with an accent and see if it works.

localicon / 2010-10-28 13:34:56   

Hi Vaska,

thanks for advise.
Finally my host changed the databese and tables as you wrote, but it did not help.
I still can not publish any "ď", "č" or "ľ".

Please, what shall I do now?
Thanks.

Vaska A / 2010-10-28 14:30:49   

Then something wasn't done correctly...because it will work if it's correct.

This thread has been closed, thank you.