⣠instead of £

[mfahl]

I have just moved my forum (IP.Board 3.4.8) & am now getting ⣠showing instead instead of £.

Any ideas on how to fix please

[mfahl]

Also noticed that i am getting … instad of spaces & other places

Found this about wordpress

can this be adapted to run on Ipb database?

UPDATE wp_posts SET post_content = REPLACE(post_content, '“', '“');
UPDATE wp_posts SET post_content = REPLACE(post_content, 'â€', '”');
UPDATE wp_posts SET post_content = REPLACE(post_content, '’', '’');
UPDATE wp_posts SET post_content = REPLACE(post_content, '‘', '‘');
UPDATE wp_posts SET post_content = REPLACE(post_content, '—', '–');
UPDATE wp_posts SET post_content = REPLACE(post_content, '–', '—');
UPDATE wp_posts SET post_content = REPLACE(post_content, '•', '-');
UPDATE wp_posts SET post_content = REPLACE(post_content, '…', '…');

[dancingbear]

On 15/01/2016 at 1:25 PM, mfahl said:

I have just moved my forum (IP.Board 3.4.8) & am now getting ⣠showing instead instead of £.

Any ideas on how to fix please

it works fine with my install.

View the page source, and one of the top lines should be 

<meta charset="utf-8">

Also, check your database setup, to ensure that both the database and any tables have "utf8_unicode_ci" as the collation.

If it doesn't have that as a collation, you'll need to google for the best way to change it - and note that changing the table collation without also running some code on the table content might not be enough by itself (I forget what I had to do to change mine, but I think some of the content data needed acting on as well as the table setup).