Jump to content

Please add Emoji support


Apfelstrudel

Recommended Posts

5 minutes ago, Apfelstrudel said:

Is there any way to convert a db?

You choose to convert it when you upgrade from 3.x or you choose it when you make a new IPS4 install.

As far as I know there's nothing "oficial" from IPS to convert a database other than the 2 cases mentioned above, we could use a tool for that...

Edited by -FP
Link to comment
Share on other sites

You need to be using MySQL 5.5.3 or higher and have all tables and columns using the utf8mb4 character set.

If you are running MySQL 5.5.3 or higher when you install IPS Community Suite or upgrade from IP.Board, you will have the option to use utf8mb4. If you upgrade later, you would need to modify the database manually (there is a good guide here). It would probably be handy to have a script to do this though - I'll bring it up for discussion :)

Link to comment
Share on other sites

  • 2 weeks later...
12 minutes ago, Cybero said:

Some Emoji works and others no...

Can you give examples? And how do you define “work” in that case? The IPS support is about storing it correctly in an utf8mb4 database (and denying the input if that database encoding is not present), not about displaying the Emoji, which also depends on your browser and the (Emoji) fonts you have installed. 

Link to comment
Share on other sites

For example this one is working (I can post and see it from my android browser (chrome) with SwiftKey keyboard) on my forum: ✈
But I can't post this one ?

When I submit message, I have the following error ans message is not posted

Quote

The value entered includes a character that is not allowed such as an Emoji.

 

Link to comment
Share on other sites

Oh ok that explains :)

What can I check to see if my database is utf8mb4  ?

By the way, thanks for your answers :) 

 

Edit: OK my bad... the following line was commented in my conf_global.php

$INFO['sql_utf8mb4'] = true;

I uncommented it and now it works ! :) 

Edited by Cybero
Solution
Link to comment
Share on other sites

  • 1 month later...
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...