Emoji Became just a question mark Vanilla 3.3

jay3rrr

Hello. after the migration to the new server. The emoji using Rich Editor when posting it became a question mark (?)

please see the attached image below...

https://us.v-cdn.net/5018160/uploads/477/Screen Shot 2020-05-14 at 6.58.50 AM.png

manticore789

Also an issue with me. including also problems with European languages in terms of accents, umlauts etc.

R_J

Most probably you will find some hints for solving that problem in that discussion: https://open.vanillaforums.com/discussion/38078/3-3-special-character-encoding-in-rich-editor-not-working-umlaute

jay3rrr

Hi @R_J . in my case, i used the default_charset = "UTF-8".. the PHP version ive used is 7.3 handler PHP-FPM...

https://us.v-cdn.net/5018160/uploads/933/Screen Shot 2020-05-14 at 11.21.09 PM.png https://us.v-cdn.net/5018160/uploads/616/Screen Shot 2020-05-14 at 11.21.20 PM.png

jay3rrr

Hi guys. Anyone.. help please..

R_J

I would still think it's that problem. Have you checked with phpinfo() that the encoding really is UTF8? Is that also the encoding of your database? Is the html encoding (when you inspect the html source of the rendered page) also UTF8 encoding?

jay3rrr

hi @R_J. Yes i'm pretty sure about it because that is the default char set to my server. i can't load the phpinfo to vanilla forum i don't know how to allow it to .htaccess. i will post here the other website's phpinfo in the same cPanel account.

i wonder why, if I using desktop/loptop the smiley appears, but not in the mobile.

Linc

Have you verified the database is identical, including that the Discussion.Body & Comment.Body fields are utf8mb4?

jay3rrr

Hi Linc.

Actually ever since that char set "UTF8" is always on my setup. Regarding to "Discussion.Body & Comment.Body fields are utf8mb4" Please see the pics below

Linc

It's weird to me that your table types are mixed between MyISAM and InnoDB. Any idea how that happened? Probably irrelevant.

The global & table-level Collation is not the same as the column-level, so these screenshots don't actually answer my question.

jay3rrr

hello Linc. i'm not an expert but i think it's that happens because i've been just forcing to used InnoDB as storage, and actually the default collation it should be general. That is the orig settings in my old and installation server of Vanilla.

in my old server i don't have any issue in Vanilla's emoji but that server is so slow and still using old environment (OS) database i been used is MySQL (i think the handler is CGI), but i need to migrate, now im using MariaDB and PHP-FPM activated. The Vanilla forum is running awesome to this server but that is the only issue, the emoji. My speculation i had a missing files (i'm not sure) because in the mobile, the emoji's option is not available.