I tried to store emoji text (
etc.) in my own database, but it just shows up some question marks(????).
I had already set the collation of my database and all tables to utf8mb4
sql: INSERT INTO my_table (my_column) VALUES ('');
Hi @ca1eb!
The database does supports emojis. However please make sure you set the encoding of your PHP script properly if you run the query from an external PHP file.
1 Like
After connecting to database with php use following
Oop extension
$connection_variable -> set_charset("utf8mb4")
Procedural extension
mysqli_set_charset($connection_variable, 'utf8mb4')
1 Like