Li3D Posted March 13, 2018 Share 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 Link to comment Share on other sites More sharing options...
opentype Posted March 14, 2018 Share Posted March 14, 2018 You need to convert the database to utf8_mb4. There is an assistent for that in the ACP. Link to comment Share on other sites More sharing options...
Li3D Posted March 14, 2018 Author Share 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 Link to comment Share on other sites More sharing options...
Li3D Posted March 14, 2018 Author Share Posted March 14, 2018 That's weird, I can use it in editor mode but icons disappear when I post Link to comment Share on other sites More sharing options...
opentype Posted March 14, 2018 Share 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. Link to comment Share on other sites More sharing options...
Li3D Posted March 14, 2018 Author Share 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 ? Link to comment Share on other sites More sharing options...
opentype Posted March 14, 2018 Share 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. Link to comment Share on other sites More sharing options...
DawPi Posted March 14, 2018 Share Posted March 14, 2018 It's there as @opentype said above. In the right column. Link to comment Share on other sites More sharing options...
Li3D Posted March 14, 2018 Author Share Posted March 14, 2018 Nothing here Link to comment Share on other sites More sharing options...
opentype Posted March 14, 2018 Share Posted March 14, 2018 Maybe it’s because your conf_global settings are wrong. You claim to use mb4, but you aren’t. Link to comment Share on other sites More sharing options...
Li3D Posted March 14, 2018 Author Share 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 Link to comment Share on other sites More sharing options...
Li3D Posted March 14, 2018 Author Share Posted March 14, 2018 That's strange, some works and other not : When posted : Link to comment Share on other sites More sharing options...
opentype Posted March 14, 2018 Share 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. Link to comment Share on other sites More sharing options...
Mark Posted March 14, 2018 Share Posted March 14, 2018 If you need help, submit a ticket and we can have a look Link to comment Share on other sites More sharing options...
Li3D Posted March 14, 2018 Author Share 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 Link to comment Share on other sites More sharing options...
opentype Posted March 14, 2018 Share 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. Link to comment Share on other sites More sharing options...
Li3D Posted March 14, 2018 Author Share 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 Link to comment Share on other sites More sharing options...
opentype Posted March 14, 2018 Share 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”. Link to comment Share on other sites More sharing options...
Li3D Posted March 14, 2018 Author Share 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. Link to comment Share on other sites More sharing options...
Li3D Posted March 14, 2018 Author Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.