How To Save Emoji in MySQL Database 😝😚 כדי לשמור סימנים מיוחדים בדטאבייס לעיתים UTF8 לא מספיק ולכן נשתמש ב - Collate מתאים ל - MultiBytes 1. ALTER DATABASE DatabaseName CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; 2. ALTER TABLE Tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; 3. $database_connection = new mysqli($server, $user, $password, $database_name); $database_connection->set_charset('utf8mb4'); https://stackoverflow.com/questions/39463134/how-to-store-emoji-character-in-my-sql-database ותודה לאח שלי חצב !
Points regarding computing that I always forget - so I write them here to find them easily and maybe other could benefit too.