search

mervick / emojionearea

Emoji Picker Plugin for jQuery
https://jsfiddle.net/mervick/1v03Lqnu/765/
MIT License
953 stars 257 forks source link

Error when uploading to MySQL using Laravel? #406

Closed vgavrilovikj closed 3 years ago

vgavrilovikj commented 4 years ago

I get the following error when I try to save it in my database: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\x9F\x98\x87\xF0\x9F...' for columnchallenges.challenges.descriptionat row 1 (SQL: insert intochallenges(hashtag,title,description,challenge_id,image_name,category_id,duration,link,user_id,updated_at,created_at) values (emojitest, Emoji Test, This is an emjoit test 😇😇, 5edaaeb0a0c24, challenge-55edaaeb0a0c481591389872.png, 2, 0, ?, 5ec443a71e40b, 2020-06-05 20:44:32, 2020-06-05 20:44:32))

bsteps commented 4 years ago

try to make your Collation as utf8mb4_unicode_ci for description field or for whole database. i also work in laravel and this been working fine

vgavrilovikj commented 4 years ago

Thank you! It works now :) On Monday, June 8, 2020, 12:56:33 PM GMT+2, NishantTadvi notifications@github.com wrote:

try to make your Collation as utf8mb4_unicode_ic for description field or for whole database. i also work in laravel and this been working fine

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.