NamelessMC

Internet Explorer

Internet Explorer is not supported. Please upgrade to a more modern browser.

Bug Problem with posting emoticons in Forum
Started by Flyprinc

Flyprinc

Flyprinc

Member
Joined
19 May 2019
Last Seen
23 Jun 2019
Topics
1
Posts
5
Minecraft
Flyprinc

Hello,

That happened when my friend made a topic, so I did reply him with emoticons, text works perfectly but emoticons disappeared.

I tried to check the files about emoticons, I think I have all files for that. Maybe I broke up while converting utf-8 files for czech language... Any ideas?

Thanks for help.

My web: aphelion.cz

Flyprinc · over 5 years ago · Last edited: over 5 years ago
Samerton

Samerton

Owner
Joined
30 Mar 2015
Last Seen
04 Feb 2025
Topics
42
Posts
1079
Minecraft
Samerton

I'm afraid I'm not sure what's going on, do you have a link to the topic which has the problem?

Samerton · over 5 years ago
Flyprinc

Flyprinc

Member
Joined
19 May 2019
Last Seen
23 Jun 2019
Topics
1
Posts
5
Minecraft
Flyprinc

http://aphelion.cz/index.php?route=/forum/topic/11-prikaz-admin/

I mean I tried to reply a message with emoticons but emoticons gone after entering the reply.

Flyprinc · over 5 years ago · Last edited: over 5 years ago
Flyprinc

Flyprinc

Member
Joined
19 May 2019
Last Seen
23 Jun 2019
Topics
1
Posts
5
Minecraft
Flyprinc

I tried change language code in MySQL nl2_posts - post_content from utf8_czech_ci to latin1_swedish_ci and emoticons changes to "???"... So I have no idea how to fix it.

Flyprinc · over 5 years ago · Last edited: over 5 years ago
Flyprinc

Flyprinc

Member
Joined
19 May 2019
Last Seen
23 Jun 2019
Topics
1
Posts
5
Minecraft
Flyprinc

I tried different emojis like U2600 emojis, it already works. Unicode emojis are problem show up...

I tested in MySQL, if I change post_content value with emojis which I copied from unicode table. It shows:
Warning: #1366 Incorrect string value: '\xF0\x9F\xA4\xA5&l...' for column 'post_content' at row 1

Flyprinc · over 5 years ago · Last edited: over 5 years ago
Samerton

Samerton

Owner
Joined
30 Mar 2015
Last Seen
04 Feb 2025
Topics
42
Posts
1079
Minecraft
Samerton

Try utf8mb4 for the database instead of latin1_swedish_ci; utf8mb4 has emoji support.

Samerton · over 5 years ago
Flyprinc

Flyprinc

Member
Joined
19 May 2019
Last Seen
23 Jun 2019
Topics
1
Posts
5
Minecraft
Flyprinc

Still not working, again changes to "????"...

Screen of MySQL: https://ctrlv.cz/1Qxs

Maybe I figured out, only one thing I can disable emoticon list from tinymce editor... Maybe the hosting has probably bad mysql version or something which I can't understand this problem.

Flyprinc · over 5 years ago · Last edited: over 5 years ago