General Support & Troubleshooting » [SOLVED] Encoding problem - Czech characters not displaying properly
1 to 3 of 3
-
I've got troubles getting PureEdit to display and store into MySQL database special Czech characters (such as ?š??žýáíé). The server is running in UTF-8, but whenever I enter some of these special characters, they get screwed - if I look into the database, they are stored in the wrong format. That means they are also displayed wrong in the back-end (in the section, where you have the list of all written posts, but when you actually click to edit one of them, they are displayd correctly inside the text boxes!).
I tried fiddling with various tips for UTF-8 I found here in the forum, but none seems to work.
Any idea guys?
-
and just noticed that the czech characters did not get displayed correctly even in my post here.
Anyway, after a lot of experimenting I got as far as this:
PE displays the characters inside admin and on the front-end correctly, as it should, BUT when I look into the database using phpMyAdmin, the body text is still saved in wrong coding (however as I said, it get's read correctly to admin area and front-end). This is kind of annoying, knowing, that the data is not stored as it should be...
-
Solved.
The problem is not actually in PureEdit, but in TinyMCE which automatically converts the special characters to entities. If you google for "TinyMCE utf-8", you'll get tons of pages with advices, but none really worked for me.
What had to be done is this:
In ../pureedit/themes/default/html/wrapper.tpl.php you have to add on line 18 (just behind tinyMCE.init {{ this line: entity_encoding: "raw",).
Now my data is encoded and saved properly into the mysql database.
1 to 3 of 3