XF 2.1 ascii code after migration just a code

[stanleyb23]

After my migration to xenforo i noticed that a lot of 👍 and other ascii codes not transformed into the corresponding icons.

PHP:s setting "default_charset" is set to "utf-8'

What can i do to replace them to either the corresponding icon or just remove them?

 

[stanleyb23]

when i replace it in mysql, how does the replacement code look like. I know it should be something like:

UPDATE xf_post SET message = REPLACE(message,'old','new');

But i don't know how to do this with &# in it.

 

[Paul B]

Which software did you import from?

You may need to redo the import with the correct character set, to avoid that issue.

 

[stanleyb23]

I m live for two months already. Another import isnt possible. I came from phpbb 2.13. It must be possible to replace and/or remove them with a sql query, character for character?

 

[Paul B]

Yes, it's possible.

You will just need to craft the queries accordingly to ensure you only remove or replace the desired content.

The example you have posted for example 👍, equates to this: .

You will need to ensure the installation supports emojis if you want to display them: https://xenforo.com/xf2-docs/manual/unicode/