Emoji are not inserting in database node js mysql

Question

Hello I am here to discus one thing. I am building up a web service that makes a goal for inserting emoji data into database field. I am working with Node JS + Mysql. I set charset to UTF-8 or utf8mb4 but this is not solving my problem. some emoji are inserting perfect { :) }. but some of are converted into square or removed. Please help me where I am doing wrong thing?

Possible duplicate of UTF-8 all the way through

Alastair McCormack
– Alastair McCormack

2016-03-29 21:51:03 +00:00
Commented Mar 29, 2016 at 21:51 — Alastair McCormack
– Alastair McCormack, Commented Mar 29, 2016 at 21:51

Manish Prajapati · Accepted Answer · 2019-11-27 16:53:43Z

93

please add charset : 'utf8mb4' in your mysql connection pool.

e.g.

var connection = mysql.createConnection({
    host : 'you_ip',
    user : 'user',
    password : 'password',
    database : 'db',
    charset : 'utf8mb4'
});

Original Post: https://www.koffeewithkode.com/emoji-are-not-inserting-in-database-node-js-mysql/

edited Nov 27, 2019 at 16:53

answered Mar 29, 2016 at 10:13

Manish Prajapati

1,6512 gold badges14 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Manish Prajapati Over a year ago

also restart your node server.

Manish Prajapati Over a year ago

keep doing coding.. :)

silent Over a year ago

you saved me dude!

Matthew Henry Over a year ago

Saved me as well! Can't believe this isn't default behaviour...

Collectives™ on Stack Overflow

Emoji are not inserting in database node js mysql

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related