Li3D Posted March 13, 2018 Posted March 13, 2018 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 Posted March 14, 2018 Posted March 14, 2018 You need to convert the database to utf8_mb4. There is an assistent for that in the ACP.
Li3D Posted March 14, 2018 Author Posted March 14, 2018 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 Posted March 14, 2018 Author Posted March 14, 2018 That's weird, I can use it in editor mode but icons disappear when I post
opentype Posted March 14, 2018 Posted March 14, 2018 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 Posted March 14, 2018 Author Posted March 14, 2018 34 minutes ago, opentype said: You should let the IPS software handle to conversion. Yep, but how to make IPS do the conversion ?
opentype Posted March 14, 2018 Posted March 14, 2018 I think it should be in the Support section. Since all my sites are mb4 already, it doesn’t show for me.
DawPi Posted March 14, 2018 Posted March 14, 2018 It's there as @opentype said above. In the right column.
opentype Posted March 14, 2018 Posted March 14, 2018 Maybe it’s because your conf_global settings are wrong. You claim to use mb4, but you aren’t.
Li3D Posted March 14, 2018 Author Posted March 14, 2018 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 Posted March 14, 2018 Author Posted March 14, 2018 That's strange, some works and other not : When posted :
opentype Posted March 14, 2018 Posted March 14, 2018 3 minutes ago, Li3D said: That's strange, some works and other not : That’s normal. Not all emoji require mb4.
Mark Posted March 14, 2018 Posted March 14, 2018 If you need help, submit a ticket and we can have a look
Li3D Posted March 14, 2018 Author Posted March 14, 2018 6 minutes ago, opentype said: That’s normal. Not all emoji require mb4. But now my database interclassement is uft8mb4_unicode_ci :s
opentype Posted March 14, 2018 Posted March 14, 2018 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 Posted March 14, 2018 Author Posted March 14, 2018 ? ⌚ ★ ? 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 Posted March 14, 2018 Posted March 14, 2018 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 Posted March 14, 2018 Author Posted March 14, 2018 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 Posted March 14, 2018 Author Posted March 14, 2018 I found the difference between both servers : PHP 7.0 VS 7.1. With 7.1 it works. Thx everyone for your help.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.