Login to download the latest version of Mint and your favorite Pepper, purchase additional licenses, or post in the Forum. Don't have an account? Create one!
I’ve installed the Bird Feeder pepper to track my blog’s subscriptions. In the Seeds panel (using Safari) there’s an encoding problem. Spanish characters are garbled.
Text is UTF-8 all the way. Any ideas what may be causing this? This also happens with the “Blog Comments” pepper.
Two possibilities.
Your MySQL database is configured to default to an incompatible character encoding. Depending on the version of MySQL you might be able to use a tool like PhpMyAdmin to adjust the collation to something like utf_unicode_cior similar.
urlencode() isn’t being kind to Spanish characters. I’m not sure what we can do if this is the issue since that is a native PHP function.
Thanks Shaun. The rest of the Mint panes are not affected by this, so it must be some issue related to the Wordpress database.
Looking through phpMyAdmin, the Mint database is “latin1_swedish_ci”. The Wordpress database is “utf8_general_ci”, except for a few tables created by plugins, which are latin1_swedish_ci.
Which one should I switch? Is there any danger in doing so?
Sorry for the delay. I’ve been traveling and under the weather.
utf8_general_ci would probably offer the greatest compatibility. I am not sure what affect switching would have, eg. if the mis-encoded values will be recognized or if they will be re-encoded into their mis-encoded equivalents in the new encoding.
I switched all the mint tables to utf8_general_ci. It didn’t change past data and it didn’t break anything.
However, I just found out that it’s a problem with Safari. It works fine on Camino.
It’s got something to do with character encoding and javascript, I’ve seen it pop-up somewhere else.
Do you want more information about it?
Have the same problem with the Outbound Links Pepper. It seems that to_title in mint_outbound table is not converted to htmlentities like i.e. resource_title in mint_visit table.
The newest Safari update cured the problem for everything… except for the “From” section of Outbound Links, which has encoding problems in both Safari and Camino.
I’m glad to see that I’m not alone on this one, I hope this can be corrected.
Just giving this a polite bump since there seems to be some fixable issue in the pepper’s code.
You must be logged in to reply. Login above or create an account
