🎁 emoji

Hello!
Add to Additional Information 🎁 and get ????
How to fix

Hello,

Did you use html editor for your textarea field? (Listing Fields > your textarea > Edit > HTML editor)

yes but anyway ????
you can check it yourself

You need to change Collation for fields to utf8mb4_bin. Read also here: https://stackoverflow.com/questions/...mysql-database

I did, but nothing has changed. Try it yourself and you will see

I solved the problem with 2-3 our clients. You can create a new ticket with the problem and I will solve it on your site too.

Dear Viktor,
I also went to phpmyadmin and change listing_fields collation to utf8mb4_bin, add emoji and the filed automatically removed it. Tried to set the field with and without html editor. Same results. Can you share the change here?

Please share here. I'll be very thankful

Ticket ID: RZU-542798

Instruction:

Open the file: ftp://includes>>classes>>dbi.class.php
at line: 96 find the line:

PHP Code:

---

Only registered members can view the code. 


---

changed to:

PHP Code:

---

Only registered members can view the code. 


---

Into Database for all database need to change collation to: utf8mb4_bin
for the table fl_listings need to change collation to: utf8mb4_bin
for fields where you want to use emoji need to change collation to: utf8mb4_bin

thank! Works

Quote:

---

Originally Posted by Viktor

Instruction:

Open the file: ftp://includes>>classes>>dbi.class.php
at line: 96 find the line:

PHP Code:

---

Only registered members can view the code. 


---

changed to:

PHP Code:

---

Only registered members can view the code. 


---

Into Database for all database need to change collation to: utf8mb4_bin
for the table fl_listings need to change collation to: utf8mb4_bin
for fields where you want to use emoji need to change collation to: utf8mb4_bin

---

NVM I figured it out, thank you for the thoughtful guide