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](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) — Alastair McCormack, Mar 29 '16 at 21:51

Manish Prajapati · Accepted Answer · 2019-11-27T16:53:43.983

87

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 '19 at 16:53

answered Mar 29 '16 at 10:13

Manish Prajapati

1,583
2
13
21

2

also restart your node server. – Manish Prajapati Mar 29 '16 at 10:14
keep doing coding.. :) – Manish Prajapati Mar 29 '16 at 10:15
3

you saved me dude! – silent Feb 14 '19 at 10:13
Saved me as well! Can't believe this isn't default behaviour... – Matthew Henry Nov 14 '22 at 09:13

Emoji are not inserting in database node js mysql

1 Answers1

Linked