UTF8 Icons

[Li3D]

Hi,

I can't use UTF8 icons (? for example) on my IPS setup.

But on the same server it works with WordPress.

Do you have any idea to make it possible with IPS ?

Thx

[opentype]

You need to convert the database to utf8_mb4. There is an assistent for that in the ACP. 

[Li3D]

Database is already in utf8_unicode_ci and there is ' sql_utf8mb4' = true in conf_global.php, not good ? Can't find the assistant :s

[Li3D]

That's weird, I can use it in editor mode but icons disappear when I post

 

[opentype]

It’s not weird. It’s expected behavior. Your database is utf8_unicode_ci — it simply cannot store those values. 
Your database needs to be converted to utf8mb4_unicode_ci as stated from the beginning. 
But don’t try to do that yourself on the database level. You should let the IPS software handle to conversion. 

[Li3D]

34 minutes ago, opentype said:

You should let the IPS software handle to conversion.

Yep, but how to make IPS do the conversion ?

[opentype]

I think it should be in the Support section. Since all my sites are mb4 already, it doesn’t show for me. 

[DawPi]

It's there as @opentype said above. In the right column.

[Li3D]

Nothing here

 

[opentype]

Maybe it’s because your conf_global settings are wrong. You claim to use mb4, but you aren’t. 

[Li3D]

7 minutes ago, opentype said:

 You claim to use mb4, but you aren’t. 

Right !

I could run the converter and everything looks fine in phpmyadmin but icons are displayed "????" :s

[Li3D]

That's strange, some works and other not :

When posted :

[opentype]

3 minutes ago, Li3D said:

That's strange, some works and other not :

That’s normal. Not all emoji require mb4. 

[Mark]

If you need help, submit a ticket and we can have a look

[Li3D]

6 minutes ago, opentype said:

That’s normal. Not all emoji require mb4.

But now my database interclassement is uft8mb4_unicode_ci :s

[opentype]

7 minutes ago, Li3D said:

But now my database interclassement is uft8mb4_unicode_ci :s

I just explained to you why some emoji work and others don’t. 

[Li3D]

?

⌚

★

?

But here and on another form I own every icons from https://www.utf8icons.com/ are correctly displayed.

I can't find why on this particular forum it can't :s

[opentype]

We explained the basics and walked you through the conversion. If it still doesn’t work, do what Mark said and open a ticket so the problem can be found directly on your installation, instead of us guessing things and you just say “it doesn’t work. it doesn’t work”. 

[Li3D]

5 minutes ago, opentype said:

you just say “it doesn’t work. it doesn’t work”

 

26 minutes ago, Li3D said:

my database interclassement is uft8mb4_unicode_ci

I don't just say it does'nt work ^^

This is an offline test forum so it's complicated to open a ticket, on my production server there is no problem.

[Li3D]

I found the difference between both servers : PHP 7.0 VS 7.1. With 7.1 it works. Thx everyone for your help.