Allowing Emojis?

Re: Allowing Emojis?

Steve H — Tue, 13 Sep 2022 13:51:33 -0500

I found this article which looks promising.
Need to convert mysql from utf8 to utf8mb4

[www.eversql.com]

Re: Allowing Emojis?

Steve H — Tue, 13 Sep 2022 12:52:24 -0500

...and they don't work here either, lol

Re: Allowing Emojis?

Steve H — Tue, 13 Sep 2022 12:51:25 -0500

I just tested the following emojis on my phorum and they don't work.
My charset is UTF-8

???? ???? ????‍♂️ ????????????

Re: Allowing Emojis?

Brummie — Tue, 13 Sep 2016 08:52:36 -0500

Or maybe it was just that symbol...

Re: Allowing Emojis?

Brummie — Tue, 13 Sep 2016 08:51:28 -0500

I've investigated more... I've added an emoji code directly to the database... It displays no problem. The problem is getting it in to the database. ✌

Re: Allowing Emojis?

Brummie — Tue, 13 Sep 2016 08:46:54 -0500

I think they should work though... The emoji is there in message preview, just not when it goes through checks before adding to the database.

Re: Allowing Emojis?

Oliver Riesen-Mallmann — Tue, 13 Sep 2016 08:40:46 -0500

In the language file you have to use UTF-8.

Re: Allowing Emojis?

Oliver Riesen-Mallmann — Tue, 13 Sep 2016 08:39:09 -0500

I think you need a new module to handle emoji, see: [www.iamcal.com] and [github.com]

Re: Allowing Emojis?

Brummie — Tue, 13 Sep 2016 08:34:27 -0500

I'm not really sure what I'm doing in all honesty... however...

Could this:

    // The charset to use for htmlspecialchars() calls. PHP does
    // not implement all available charsets, which might result in
    // warning messages if an unsupported charset is used.
    //
    // See [www.php.net] for info on charset
    // compatibility. If the charset that you specified above is
    // compatible with htmlspecialchars(), then you can leave this
    // variable empty. Otherwise, specify a compatible character
    // set (ISO-8859-1 is usually a good choice for this).
    $PHORUM["DATA"]['HCHARSET']="";

Could this be used in conjunction with this [teamtreehouse.com]?

Re: Allowing Emojis?

Oliver Riesen-Mallmann — Tue, 13 Sep 2016 08:12:59 -0500

utf8mb4_general_ci looks like something from mysql...

For php look here: [www.php.net]

Re: Allowing Emojis?

Brummie — Tue, 13 Sep 2016 08:07:10 -0500

Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in common.php on line 750
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 156
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 158
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in api/user.php on line 1488
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in api/user.php on line 1488
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in api/user.php on line 1488
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in api/user.php on line 1488
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in api/user.php on line 1488
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 156
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 158
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 156
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 158
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 156
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 158
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 156
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 158
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 156
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 158
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 156
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 158
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 156
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 158
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: htmlspecialchars(): charset `utf8mb4_general_ci' not supported, assuming iso-8859-1 in format_functions.php on line 174
Warning: Cannot modify header information - headers already sent by (output started at format_functions.php:174) in /tmp/tpl-Acorns-header-4dbd9fc1075479ca60fb2b1769c4773f.php-stage2 on line 5

That didn't work then haha

Re: Allowing Emojis?

Oliver Riesen-Mallmann — Tue, 13 Sep 2016 07:54:39 -0500

Quote
Brummie
However I have no idea where that is stored.

In the language file: [github.com]

Re: Allowing Emojis?

Brummie — Tue, 13 Sep 2016 07:51:54 -0500

I've gone through format_functions.php where it seems to format the body before it's inserted, however can't seem to narrow it down. I found this line however:

[code="php"]
$escaped_body = htmlspecialchars($body, ENT_COMPAT, $PHORUM["DATA"]["HCHARSET"]);
[/code]

And wondered whether there is a character set that is explicitly supplied in the $PHORUM array... However I have no idea where that is stored.

Re: Allowing Emojis?

Scott Finegan — Tue, 13 Sep 2016 07:38:28 -0500

The character(s) is|are stripped so that injectable code does not get into the database.
I did not test allowing html in the message body, you could try this. (change in the admin I believe)

One of the smilies doesn't work either.
Several years ago I spent several hours looking at this, and decided to leave it alone due to the amount of testing required to verify that code could not be injected.

Re: Allowing Emojis?

Brummie — Tue, 13 Sep 2016 07:34:19 -0500

I think it may be down to the character set though? See here for example

Re: Allowing Emojis?

Oliver Riesen-Mallmann — Tue, 13 Sep 2016 07:30:07 -0500

Hi Brummie,

the Smileys Module simply replaces text smileys by html image tag...

You can add your own smiley definitions in the module settings.

Regards
Oliver

Re: Allowing Emojis?

Brummie — Tue, 13 Sep 2016 07:28:00 -0500

Smileys work... Emojis from iOS etc, don't?

Re: Allowing Emojis?

Oliver Riesen-Mallmann — Tue, 13 Sep 2016 04:39:38 -0500

Hi Brummie,

please check path value in the module settings.

Can you provide a link to a post which should include Smileys?

Regards
Oliver

Re: Allowing Emojis?

Brummie — Tue, 13 Sep 2016 04:27:37 -0500

Yes but it doesn't show emojis?

Re: Allowing Emojis?

Oliver Riesen-Mallmann — Tue, 13 Sep 2016 03:42:28 -0500

Hi Brummie,

you are using the Smileys Module?

Regards
Oliver

Allowing Emojis?

Brummie — Mon, 12 Sep 2016 15:05:41 -0500

I'm trying to get emojis to work but for some reason the character is being removed when submitted to the database. Any ideas?