Menu
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?
741
Adding new emoji js . Then run npm run-script emojiparse in the project directory or node emojiparse in the lib directory. This should generate the new emoji. json file and output Done. .
As some emojis are using unicode code points beyond what can be represented with a three byte utf8 encoding, it is recommended to use utf8mb4 for columns that are used to store emojis.
The unicodes for emoticons are fully supported by the UTF-8 encoding; however, MySQL's utf8 does not! To save emoticons to a MySQL database we need to use utf8mb4 .
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/
51
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
