How to store Emoji Character in MySQL Database

by

1) Database: Change Database default collation as utf8mb4.

2) Table: Change table collation as CHARACTER SET utf8mb4 COLLATE utf8mb4_bin.

Query: 

ALTER TABLE Tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin

3) Code: 

INSERT INTO tablename (column1, column2, column3, column4, column5, column6, column7)
VALUES ('273', '3', 'Hdhdhdh😜😀😊😃hzhzhzzhjzj 我爱你 ❌', 49, 1, '2016-09-13 08:02:29', '2016-09-13 08:02:29')

4) Set utf8mb4 in database connection: 

  $database_connection = new mysqli($server, $user, $password, $database_name); 
  $database_connection->set_charset('utf8mb4');

More Related Contents:

  1. Delimiters in MySQL
  2. String concatenation in MySQL
  3. Unknown column in ‘field list’ error on MySQL Update query
  4. How to check if mysql database exists
  5. Change auto increment starting number?
  6. SELECT * FROM multiple tables. MySQL
  7. How to get the difference between two timestamps in seconds
  8. INSERT INTO…SELECT for all MySQL columns
  9. Export and Import all MySQL databases at one time
  10. MySQL: Select top n max values?
  11. tomcat7 – jdbc datasource – This is very likely to create a memory leak
  12. MySQL search in comma list [duplicate]
  13. What is MySQL’s default ON DELETE behavior?
  14. Select from one table where not in another
  15. MySQL error 1022 when creating table
  16. How do I setup ASP.NET MVC 2 with MySQL?
  17. mysql DECLARE WHILE outside stored procedure how?
  18. SELECT query return 1 row from each group
  19. MySql Single Table, Select last 7 days and include empty rows
  20. How can I check MySQL engine type for a specific table?
  21. mysql SQL: specific item to be first and then to sort the rest of the items
  22. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  23. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  24. Where does MySQL store database files on Windows and what are the names of the files?
  25. When is a timestamp (auto) updated?
  26. Should I normalize my DB or not?
  27. MySql Query Replace NULL with Empty String in Select
  28. How to handle a query with special characters / (forward slash) and \ (backslash)
  29. Does MySQL support historical date (like 1200)?
  30. mySQL query to search all tables within a database for a string?

Leave a Comment