UTF8 to Latin

As long as you have access to phpMyAdmin (most hosting providers offer this in their control panel) and a plain text editor, there is a much easier way to do it.

I did a quick write-up on converting from latin1 to utf8 last month. Just swap the terms as necessary and you should be fine. The whole process is easier and certainly a lot safer than messing around with the MySQL command line.

Hi James

I’ve tried this and still no joy. The only difference for me trying it was that I was using Textpad on a PC therefore step 5 (Select all of the text and select “Unicode (UTF-8)” from the Text/Reload Text With Encoding menu.) was skipped as Textpad doesn’t have this option. I assume this is only a text formatting option anyway?

The problem still exists for creating new posts in WordPress and comments (posted with Buddypress). For example fáda tést í ó abú appeared as f?da t?st ? ? ab? and is being saved in the DB like that or sometimes the accent will not be displayed and the rest of the text will be omitted completely.

Thanks

Do you have latin1 set for the DB_CHARSET in the wp-config.php file?

https://codex.www.ads-software.com/Editing_wp-config.php#Database_character_set

Hi James, that seems to have worked for the WP blog and Buddypress usernames thanks! The only problem remaining is the twitter feeds I have displayed at the top of the page. I checked the charset for the page in header.php and this is set to charset=<?php bloginfo(‘charset’); which I assume is going to pick up the ‘latin1’ set in the reading section. Aithníonn is displayed ok in twitter but it is Aithn?-onn on the page and when I view source on the page. Any thoughts on that?

What are you using to bring in the Twitter feeds?

I’ve just realised that the home page is fine whereas the other pages aren’t. Surely they all use the same header.php?

sorry when I say home page, it’s the initial login page. When the user logs in the problem then occurs, but again they should both be using header.php

I’d assume so. You’ve done all the right steps. Are you using any caching plugins? Have you checked from any other browsers on any other computers?

I’ve noticed the for comments (i.e. posts) its on the general home page it’s working fine, but for the comments for groups, eg whats new in group 1, these are not rendering the accented letters.

This also applies for the twitter linkage, for which I am using Twitter for WordPress 1.9.7

Hi

Just wondering if anyone knows when BP 1.3 is out? I’ve had this bug for sometime now, similar to this one for Portuguese. https://buddypress.org/community/groups/how-to-and-troubleshooting/forum/topic/i-have-a-charset-problem/

I’ve did all the manual DB conversions etc and the end result seems to be an AJAX Groups Buddypress bug: if I type an accented Irish charecter á é í ó or ú into anywhere in the groups area, it comes up strange eg ??r instead of ár (within an AJAX content area with sub headings of HOME MEMBERS etc) whereas on my homepage (non AJAX) it seems fine. The intial thread was here https://buddypress.org/community/groups/how-to-and-troubleshooting/forum/topic/from-latin1-to-uft8-issues/

If 1.3 fixes this and is out soon it would solve a major problem for me. I have been delaying properly releasing this site due to this bug and was considering migrating to another social system as I heard Buddypress was no longer supported but if that’s not true and 1.3 fixes this I’d be happy to hold on a while.

regards
Dónal